dbms_output.putline alternative?

[Jeff Kish]

Hi.

I'm trying to log some information in a transaction that fails (no commit...). It is alot and I was wondering if there is an alternative to using the dbms_output.putline as there is a 1M limit to output.

thanks
Jeff

 

[ScottMattes]

a procedure with the autonomous setting will allow you to insert values into a table and commit them.
http://www.psoug.org/reference/autonomous_tx.html

 

[Jeff Kish]

thanks Scott. I have not familiarized myself with this before.

Jeff

 

[D.]

Jeff,

Depends what version of Oracle you are using. From Oracle 10g Release 2 the buffersize is unlimited, so no 1Mb limit any more.

Cheers,
D.

 

[Claus Pedersen]

a procedure with the autonomous setting will allow you to insert values into a table and commit them.

Please be aware, though, that using autonomous transactions can have impact on performance, as they take considerable time to spawn a new (temporary) session, perform the code and commit.

So, use with caution in production environments.