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

Home -> Community -> Usenet -> c.d.o.server -> Re: Testing Stored Procedures with OUT-Parameter in QSL*Plus

Re: Testing Stored Procedures with OUT-Parameter in QSL*Plus

From: Scott Mattes <Scott_at_TheMattesFamily.ws>
Date: Wed, 18 Sep 2002 14:07:35 GMT
Message-ID: <HM%h9.7383$Zi.2220240@news1.news.adelphia.net>


use an anonymous PL/SQL block.

"Lars Steinmetz" <no_spam_lsteinmetz_at_jakrause.com> wrote in message news:1032356916.851814_at_news.thyssen.com...
> Hello NG,
>
> how can I test my stored procedure witch has an OUT parameter with
SQL*Plus?
> E.g.
> call MY_STORED_PROCEDURE(???, 1,2,3,'A', 'B', 'C');
>
> I have to create a variable first to get this value from the procedure,
but
> how?
>
> Thanx for you help!
>
> Greetings Lars!
>
>
Received on Wed Sep 18 2002 - 09:07:35 CDT

Original text of this message

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