Re: SQLPlus & HTML page

From: Andrew Hardy <spam.from.news_at_AdvanticaTech.com>
Date: Thu, 30 Jan 2003 11:44:32 -0000
Message-ID: <b1b37g$qcv$1@sun-cc204.lut.ac.uk>

Chris,

"Chris" <chris_at_nospam.com> wrote in message news:S07_9.24$Mn.34_at_news-srv1.fmr.com...
> Hi Again,
>
> Well, I found out that the utility owa_utility.showpage allows me to see
the
> page.
> SQL>set serveroutput on
> SQL>spool mypage.html
> SQL>execute my_procedure
> SQL>execute owa_util.showpage
>
> However, if the page has a lot of data (for example, displays a large
> table), the buffer overflows and the html page is not finished properly.
> *

You could have a look at owa.get_page - this grabs the stuff from the htp buffer and puts it into a PLSQL table. Once there, you could do what you like with it...

> > I have no problem viewing this page using SQL Navigator but when I
execute
> > the same procedure from SQL Plus I cannot see this page, even if I spool
> it.
> > The spool is empty.

Correct, the data being produced is not going to the spool queue, it's going to the 'htp' queue.

Andy Received on Thu Jan 30 2003 - 05:44:32 CST