Subject Re: [IBO] Selectable stored procedures and IBO
Author Helen Borrie
At 10:10 PM 10/09/2007, you wrote:
>Hello, how are you?
>
>Regarding your last post i tried to do the following:
>
>A TIBOQuery that on the SQL property has "SELECT * FROM SSP(:Param)";
>On that same TIBOQuery, the EditSQL property is like this: "EXCUTE
>PROCEDURE ESP(:SSP_Field)";
>
>This is simply not working! The ESP has several instructions, but to
>make it simpler, i made a very simple update statement. If i
>copy/paste the update statement directly on the EditSQL property it
>works fine, if i put the exact same code on the ESP, when ever i try
>to issue a post to the dataset the following error is displayed:
>
>Dynamic SQL Error
>error code = -303
>internal error
>
>What am i doing wrong here? I Need to use an ESP as explained before
>but i simply cant get it to work!
>Any enlightenment would deeply appreciated!

Have you tested your EXECUTE PROCEDURE statement in IB_SQL?

Helen