thanks heap
"Karsten Farrell" <kfarrell_at_belgariad.com> ¼¶¼g©ó¶l¥ó·s»D
:MPG.191ade7c2e8f04cb989764_at_news.la.sbcglobal.net...
> fake_at_fake.com said...
> > assume i have a table abc
> >
> > create or replace procedure showabc is
> > begin
> > select * from abc;
> > end;
> > /
> >
> > what is the problem ?
> >
> > thanks again
> >
> PL/SQL does not automatically display the output of a SELECT statement
> (you need dbms_output.put_line or similar for that). So you need to put
> your output into a variable or ref cursor ... which means you need to
> limit it to one row returned (if in a variable) or place a output ref
> cursor in the procedure args.
> --
> /Karsten
> DBA > retired > DBA
Received on Fri May 02 2003 - 10:32:17 CDT
