Can't find the answer to this in the excellent "The Firebird Book".
I have a query myQuery : select a,b,c from stored_proc1(:myParam).

I issue (using Delphi as an example):
myQueryPrepare;
myQuery.Params[0] := 1;
myQuery.Open;
... bla bla bla...
myQuery.Close;

myQuery.Params[0] := 2;
myQuery.Open;
... bla bla bla...
myQuery.Close;

Question : at what point are the SQL statements embedded within
stored_proc1 actually prepared?

regards, Colin