Contents tagged with Pragma

• Oracle Pragma Autonomous Transaction

  Tags: Oracle, Pragma, Autonomous, Transaction

  Friday, June 8, 2018 10:03:58 AM

  1 Comment

  CREATE FUNCTION FN_MYAPP_WS_LOGGERreturn VARCHAR2as PRAGMA AUTONOMOUS_TRANSACTION;BEGIN

  /* needs grant select on v$session (or any dictionary), but not via role */INSERT INTO MYAPP_WS_LOGGERSELECT * … more