Re: DBMS_SNAPSHOT error...

Magnus Andersen wrote:
> HI All,
>
> I'm suddenly receiving an ORA-04092 error when trying to do a complete
> refresh of a snapshot. I haven't had any changes to the database.
>
> Database version: 8.1.7.2
> OS: HP-UX 11.0
>
> Error:
> SQL> exec dbms_snapshot.refresh('ITM_VNDR_UOM_PR','C');
>
> begin dbms_snapshot.refresh('ITM_VNDR_UOM_PR','C'); end;
>
> ORA-04092: cannot COMMIT in a trigger
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 658
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 641
> ORA-06512: at line 1
>
> Any thoughts?
>
> Thanks,
> Magnus
>

You cannot commit in a trigger.
Have the trigger call a package, and an autonomous transaction.

If this is in dbms_snapshot, you applied a patch (naughty boy!). You should be on 8.1.7.4.25, by the way.

Someone must have changed something, no matter what you want us to believe

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...