sql.pno keeps restarting at 1

[mrpaulwass]

I'm writing a script which creates many small separate reports within the same SQL.

Each time I set up a new title.

The sql.pno restarts every time at 1, which is NOT what I want.

Any way to alter this behavior? Or can I use a variable within my script (like variable page_no number). If yes, how can I use within TTITLE and then increment it?

Thanks,

Paul

One more quicky. Can SQL and PL/SQL be mixed within the same script?

For example

variable page_no number
begin
age_no := age_no + 1;
end;
print page_no

I couldn't get this to work.