Subject Re: [IBO] IB_WISQL problem (maybe)
Author Paul Little
Helen Borrie wrote:
> At 12:30 PM 05-04-01 +0100, you wrote:
> >I am trying to load a stored procedure from a script file using IB_WISQL
> >and it loads and executes ok but when I click on "commit and end" I get
> >an error:
> This might be just a misunderstanding in terminology, but...
> You CREATE a stored procedure from a script (loading the script into the script window) and then you execute the script; then you click the COMMIT button, yes?
> Is this where the error is occurring?

Yes. Well, at least that is what I thought. Certainly when I clicked on
the commit button I got the error. But I just tried it again and got a
message saying that the procedure already existed in the database. I
refreshed the browse window and, sure enough, there it was. I then tried
clicking the excecute button on the proceduresand got the same error as


> >ISC ERROR CODE:335544343
> >
> >invalid request BLR at offset 8431
> >context not defined (BLR error)

the sp code is in the attachment


btw, 'scuse my ignorance but what is a "blr error"

[Non-text portions of this message have been removed]