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_at_newsread4.arcor-online.net>
>
>
> and to dump x and y values?
>
> Thanks
Date: Wed, 13 Jul 2005 15:06:36 +0200
Message-ID: <42d51317$0$28159$9b4e6d93_at_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 - 15:06:36 CEST