Re: ACCEPT in SQL*Plus

you need to change your anonymous block to read

begin
dbms_output.enable(100000);
dbms_output.put_line(:abc);
end;
/

"Francesco Sblendorio" <sblendorio_at_despammed.com> wrote in message news:b6ujf9$ko5$1_at_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 - 09:02:20 CDT