Re: SQLPlus & HTML page

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. *
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 38505 bytes

The documentation says that the owa_util.showpage procedure uses dbms_output and thus is limited to 255 characters per line and an overall buffer size of 1,000,000 bytes

Does anybody knows another way to see the html page?

Many thanks
Chris

"Chris" <chris_at_nospam.com> wrote in message news:Vu5_9.22$Mn.37_at_news-srv1.fmr.com...
> Hi,
>
> I'm using a PL/SQL procedure (using the htp package) to create a html
page.
> 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.
> Would you know how I can see this page?
>
> Many thanks,
> Chris
>
>
Received on Thu Jan 30 2003 - 04:23:03 CST