Subject | Re: [IBO] strange problem with stored procedure |
---|---|
Author | Helen Borrie (TeamIBO) |
Post date | 2002-02-22T14:18:12Z |
At 10:55 AM 22-02-02 +0100, you wrote:
regards,
Helen Borrie (TeamIBO Support)
** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com
>Hi all,[snip stored proc code involving a blob]
>
>I run into a problem when trying to use the following stored procedure from
>a TIB_cursor:
>it returns the following error message :The first thing to know is which database and version you are using.
>ISC ERROR CODE:335544384
>
>ISC ERROR MESSAGE:
>internal error
>
>STATEMENT:
>TIB_Cursor: "<TApplication>.frmSQL.crEdit."
>
>SQL ERROR CODE:-902
>
>When I ran the code outside of a stored procedure (Select ...... Into.....)
>everything goes allright and I get the results I expected. so what I am a
>doing wrong? How can I make this work in a stored procedure?
regards,
Helen Borrie (TeamIBO Support)
** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com