Subject Re: [IBO] TIBOStoredProc - Error
Author Jason Wharton
> I made a Stored Procedure and works very well.
> In my application I put a TIBOStoredProc and when
> I active the TIBOStoredProc give me the message
> 'Error Code 335544327 - Invalid request Handle'.
> Why ?

This results because you are trying to open a cursor for returning a batch
of records when in reality you have prepared an EXECUTE PROCEDURE statement
which is only designed to return a single row of data and uses and entirely
different API call to do so.

But, I did figure out a way to have TIBOStoredProc go ahead and treat that
one record as a complete dataset. Now you can go ahead and set it to Active
= true or call open instead of ExecProc. It will accomplish essentially the
same thing as before, it's just now more flexible about how it can be
interacted with.

Though, I will say using the ExecProc method is what you should do. If you
want to get a dataset out of a stored procedure then please just use an
IBOQuery component with a select statement.

Regards,
Jason Wharton
http://www.ibobjects.com