How EXECUTE STORED  with params, with TIBconnection ?
lazarus / 16-Databases

----------------------------------------------------------------------
Fortuna1 · 2012-05-18 05:46

SQLQuery1.SQL.Text:='EXECUTE PROCEDURE STOREDprocSAMPLE'; 
SQLQuery1.ParamByName('KEYKEY').ASinteger:=1;

----------------------------------------------------------------------
exdatis · 2012-05-18 07:19

SQLQuery1.SQL.Text:='Select * From procSAMPLE(:KEYKEY)';
then
SQLQuery1.ParamByName('KEYKEY').ASinteger:=1;
or
SQLQuery1.Params[0].ASinteger:=1;

----------------------------------------------------------------------
exdatis · 2012-05-18 07:25

Also,
if there is no resulting set you can:
IBConnection.ExecuteDirect(script_command);
 //script_cmd:= Format('EXECUTE PROCEDURE procSAMPLE(%d)', [1]);