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

Home -> Community -> Usenet -> c.d.o.tools -> Re: SqlPlus batch

Re: SqlPlus batch

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 13 Jul 2005 15:06:36 +0200
Message-ID: <42d51317$0$28159$9b4e6d93@newsread4.arcor-online.net>


ciccio schrieb:
> Noel wrote:
>
> Wow! Faster than the speed of light!
>

>> Enclose it in <declare begin end> block.
>> declare
>>   x integer;
>>   y varchar2(2000);
>>   begin
>>    myproc(sysdate - 10, sysdate, 1, x, y);
>>   end;
>> /

>
>
> and to dump x and y values?
>
> Thanks

To show the values of OUT variables you can use DBMS_OUTPUT.PUT (or PUT_LINE) procedures ( there are some restrictions concerning the length of arguments ).
Also you can use bind variables and show the values with sqlplus PRINT command.
Also you can abbreviate < begin myproc; end; > to < exec myproc > if you are using sqlplus.

Best regards

Maxim Received on Wed Jul 13 2005 - 08:06:36 CDT

Original text of this message

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