Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ACCEPT in SQL*Plus
I know that I cannot print using dbms_output.put_line with out the following
command:
set serveroutput on
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3e92d66b$0$22004$ed9e5944_at_reading.news.pipex.net...
> 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 - 19:02:33 CDT
![]() |
![]() |