Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Testing Stored Procedures with OUT-Parameter in QSL*Plus
try this in SQL*Plus
var a number;
exec MY_STORED_PROCEDURE(:A, 1,2,3,'A', 'B', 'C');
select :A from dual;
print A
try this to see the type of host variables.
var x qwerty
"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 - 10:05:45 CDT