Why can't I commit in a before or after insert trigger? Any work around? I cannot avoid the commit becuase I'm calling an Oracle supplied package that has a commit in it!!
/oracle> oerr ora 4092
04092, 00000, "cannot %s in a trigger"
// *Cause: A trigger attempted to commit or Rollback.
// *Action: Rewrite the trigger so it does not commit or rollback.