description of error in stored procedure

[Ola Fjelddahl]

hi.

If I am in a stored procedure and get an error. How do I retrieve the
description of the error?

TIA

/OF

[Sean McKeough]

Need more info...what language is the sp, what parm style are you using,
what do you mean by 'retrieve the description of the error'? Do you
mean, how can you pass back the sqlcode info?

Ola Fjelddahl wrote:

> hi.
>
> If I am in a stored procedure and get an error. How do I retrieve the
> description of the error?
>
> TIA
>
> /OF

[PM \(pm3iinc-nospam\)]

Investigate the use of GET DIAGNOSTICS.

PM