Thanks Larry,

I'll start using the statement in my SPs.

Paul


>Paul,
>I'm not sure how OAS works. If it uses a separate session context for each request then the pragma instruction will be of no use. It won't hurt anything, it simply adds nothing. Sorry I can't be of more help here.
>
>IAC, here is the syntax for the pragma instruction:

>create or replace procedure sp_example is
>   pragma AUTONOMOUS_TRANSACTION
>
>   /* variable declarations */
>begin
>   /* do some processing */
>end;

>I put the compiler instruction before anything in the declaration block.
>
>HTH.
>