Getting ORA-00604 & ORA-06519

[darrenttl]

Hi,

I am getting the following error:
ORA-00604:error occurred at recursive sql level 1.
ORA-06519:active automous transaction detected and rolled back.
This error occurred when I was trying to connect to the database user....

This is my logon trigger.
create or replace trigger gy_logon_trigger
after logon on database
declare
PRAGMA AUTONOMOUS_TRANSACTION;
begin
ctx.set_emp;
end;

Please advice. Thanks

Regards,
TTL

[amitpatel66]

Hi,

I am getting the following error:
ORA-00604:error occurred at recursive sql level 1.
ORA-06519:active automous transaction detected and rolled back.
This error occurred when I was trying to connect to the database user....

This is my logon trigger.
create or replace trigger gy_logon_trigger
after logon on database
declare
PRAGMA AUTONOMOUS_TRANSACTION;
begin
ctx.set_emp;
end;

Please advice. Thanks

Regards,
TTL

ORA-06519: active autonomous transaction detected and rolled back

Cause: Before returning from an autonomous PL/SQL block, all autonomous transactions started within the block must be completed (either committed or rolled back). If not, the active autonomous transaction is implicitly rolled back and this error is raised.

Action: Ensure that before returning from an autonomous PL/SQL block, any active autonomous transactions are explicitly committed or rolled back.

[darrenttl]

ORA-06519: active autonomous transaction detected and rolled back

Cause: Before returning from an autonomous PL/SQL block, all autonomous transactions started within the block must be completed (either committed or rolled back). If not, the active autonomous transaction is implicitly rolled back and this error is raised.

Action: Ensure that before returning from an autonomous PL/SQL block, any active autonomous transactions are explicitly committed or rolled back.

Thanks for ur replied. FYI, There is only 1 and the 1st autonomous PL/SQL in my logon trigger. :)

[amitpatel66]

Thanks for ur replied. FYI, There is only 1 and the 1st autonomous PL/SQL in my logon trigger. :)

GIVE A COMMIT OR ROLLBACK in the trigger that you have written