Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ACCEPT in SQL*Plus
>> 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
![]() |
![]() |