Subject TIBOQuery and selectable SP
Author Ronan van Riet
Hello,

I am new to IBO so please bear with me!

I am having problems retrieving a dataset with my TIBOQuery.

My SQL looks like: EXECUTE PROCEDURE SP_GET_MY_PROJECTS(:I_CST_CON_ID)
SP_MY_PROJECTS can return multiple records in the dataset, when I call the
SP from IBExpert.

I am using the following code to retieve the dataset.

with IBO_QRY_MY_PROJECT do begin
Close;
if not prepared then prepare;
ParamByName('i_CST_CON_ID').Value := pWebApp.Literal['CST_CON_ID'];

IBO_QRY_MY_PROJECT.Active := true;
end;

It fails with error: invalid request handle.

What is causing this? What can I do to fix it?

Kind regards
Ronan van Riet