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

Home -> Community -> Usenet -> c.d.o.misc -> Re: ACCEPT in SQL*Plus

Re: ACCEPT in SQL*Plus

From: Francesco Sblendorio <sblendorio_at_despammed.com>
Date: Tue, 8 Apr 2003 15:41:30 +0200
Message-ID: <b6ujf9$ko5$1@newsreader.mailgate.org>


>> variable abc number;
>> accept abc;
>>
>> begin
>> dbms_output.put_line( :abc );
>> end;
>> /

Thanks for your help.
I tried the script you posted: it's executed without errors, but it doesn't print nothing out, although I already launched "set serveroutput on".

What's the difference between a "variable" and a "host variable"? Received on Tue Apr 08 2003 - 08:41:30 CDT

Original text of this message

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