Re: Clearing output from htp.p and starting over within PL/SQL

Hi.

mdr wrote:
> We have a need to trap errors in a PL/SQL procedure running under the OWS.
> We can trap them with EXCEPTION, but in this case we want to basically
> throw away any output generated (with htp.p) and start over. Does anyone
> know how to clear the output without showing it in the browser?

Have a look at the variables 'www_user.htp.rows_out' and 'www_user.htp.rows_in'. I've used these to access the HTP buffers from PL/SQL. Jamie Keir

-- 
+--------------------+---------------+----------------------------+
| Oracle 7     DBA   | Digital Unix  | Jamie Keir                 |
| Developer*2000     | Windows NT 4  | jkerr_at_jameswatt.ac.uk      |
| PL*SQL             | AmigaOS 3     |                            |
|                    | C / C++       | Now if I could just get    |
| Alpha AXP          | M68040 Asm    | them to *pay* me for it... |
+--------------------+---------------+----------------------------+