That is true, but francesco says that he (or she) has done that already. You
need to assign a buffer to hold the output, and then issue set serveroutput
to flush the buffer to screen.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Joe Chancellor" <Joe at NoSP4M eat-me dot net> wrote in message
news:v96oopipo5231f_at_corp.supernews.com...
> 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 Wed Apr 09 2003 - 03:08:30 CDT
