Re: How can I access error information from PL/SQL procedure

"Terri I." <teresni_at_ucia.gov> wrote in message news:b1f8b3bc.0108281142.1c7b509e_at_posting.google.com...
> I had a PL/SQL function defined to return a status code so calling
> program would know whether or not function ran properly. However, I
> needed to call this function from a block of JavaScript code so now
> rather than calling the function directly, I am running it
> 'indirectly' by opening a browser window with the name of the function
> in the URL (couldn't find a better way to do this).
>
> So now my problem is that I cannot access the status code the function
> was going to return. Is there a way to set something in the PL/SQL
> procedure/function that can be access from the calling JavaScript
> code?

Convert your function to a procedure, and use the status code as an out parameter to the procedure.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Aug 28 2001 - 14:51:59 CDT