Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How access out parameter when pl/sql procedure called from javascript?

Re: How access out parameter when pl/sql procedure called from javascript?

From: Ron Reidy <ron_at_indra.com>
Date: Fri, 12 Oct 2001 14:17:56 -0600
Message-ID: <3BC74FF4.96DEFC5@indra.com>


"Terri I." wrote:
>
> I have a PL/SQL procedure defined to return a status code via an OUT
> parameter so the calling program wil know whether or not the procedure
> ran properly. I need to call this procedure from a block of
> JavaScript
> code so I am running it 'indirectly' by opening a browser window with
> the name of the procedure in the URL.
>
> How can I access the value of the OUT parameter when launching a
> PL/SQL procedure via a URL call??

This parameter needs to be "IN OUT". Initialize before making the SP call and test after.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Fri Oct 12 2001 - 15:17:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US