Re: Question about report formatting

Hi,

[Quoted] to set up a counter i created i sequence. ( Probably it would be better to declare a global variable and increase it's value, but i don't know how to do that (i'm still learning oracle:-)...any suggestion would be appriciated )

So, as i said, i declared a sequence, and it's called (in the body of the FORMAT trigger) in this way:

DECLARE
    i NUMBER;

i := SEQ_FORMAT_REPORT.NEXTVAL;

IF MOD(i,2)=0 THEN
...
ELSE
...
END IF; When i try to compile it, i get the following error message:

"Table, View or Sequence reference 'SEQ_FORMAT_REPORT.NEXTVAL' not allowed in this context".

What am i doing wrong?

"Russell Kingham" <kinghams_at_bigpond.com> wrote in message news:Ew998.3840$BE4.10358_at_newsfeeds.bigpond.com...
> Hi
> Set up a counter and increment it for each time the frame fires on a page.
> In the same format trigger check if the counter is odd/even and use the
> built in srw.set_attr. Check in the help.
> l8r
Received on Sun Feb 10 2002 - 13:27:14 CET