Subject | Re: incorrect error message |
---|---|
Author | Nick Upson |
Post date | 2008-09-19T14:50:31Z |
ok, I've worked out what is happening, the script starts off by defining all
SP's with their input & output args but they only contain "exit". so at that
point no SP contains a suspend.
Once they have all been created like this, there is a series of alter
statements to 'fill-in' the body of the SP's, I imagine it's done this way
to avoid having to worry about dependancies BUT now this cross-check means
that it is necessary to take into account the dependancy in order for the
rdb$procedure_type to be correct when the calling SP is altered to it's
correct contents.
[Non-text portions of this message have been removed]
SP's with their input & output args but they only contain "exit". so at that
point no SP contains a suspend.
Once they have all been created like this, there is a series of alter
statements to 'fill-in' the body of the SP's, I imagine it's done this way
to avoid having to worry about dependancies BUT now this cross-check means
that it is necessary to take into account the dependancy in order for the
rdb$procedure_type to be correct when the calling SP is altered to it's
correct contents.
[Non-text portions of this message have been removed]