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: Marco Blanco <mblanco_at_performance2000.net>
Date: Wed, 18 Sep 2002 17:05:45 +0200
Message-ID: <3d889cc4$1_3@news.arrakis.es>


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

Original text of this message

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