APEX

Hi, Guys:

I try to set up autonomous transaction as a process after button pressed, I have this error:

1 error has occurred•ORA-06550: line 4, column 8: PLS-00710: Pragma AUTONOMOUS_TRANSACTION cannot be specified here


Could anyone give me a hint?

declare

PRAGMA AUTONOMOUS_TRANSACTION;

begin

  if :P2200_CURRENT_SETTING='Y' then
    
    update SOR_APEX_CONFIG 
    set CURRENT_SETTING='N';
    
  end if;

  update SOR_APEX_CONFIG
  set APEX_SERVER=:P2200_APEX_SERVER,
  PORT=:P2200_PORT,
  APEX_STRING=:P2200_APEX_STRING,
  CURRENT_SETTING=:P2200_CURRENT_SETTING,
  APP_ID=:P2200_APP_ID,
  CONFIG_DATE=sysdate
  where ROWID=:P2200_ROWID;
  
   commit;
   
   
end;

I am using Oracle 11g, APEX 4.1

Edited by: lxiscas on Aug 23, 2012 1:56 PM