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
before.

i.e.....

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

the sp code is in the attachment

TIA
Paul


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

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