Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: please help = pl/sql
The output is there - you just didn't see it ( output was 3,4,7,8,10 -
all the missing invoices ). All I wanted to do was demonstrate a way
of doing it without fetching every row in the table by only fetching
the rows where preceding invoices were actually missing...
Stéphane LEJAY <stephane.lejay_at_wanadoo.fr> wrote in message news:<bdgko8$e7r$1_at_news-reader4.wanadoo.fr>...
> Apparently, your problem is the results of the PL/SQL procedure is
> not displayed. Don't forget to use SET SERVEROUTPUT ON before the
> PL/SQL block (it is an option of SQL/Plus). See the doc for more
> information.
>
> unknown wrote:
>
> > 3
> > 4
> > 7
> > 8
> > 10
> >
> > PL/SQL procedure successfully completed.
Received on Fri Jun 27 2003 - 10:21:46 CDT
![]() |
![]() |