i am writing simple procedure but its erroring out due to alter
this is on logical standby
it throws the following errorCode:create or replace PROCEDURE pr_test as begin declare user VARCHAR2(50 BYTE); adfg VARCHAR2(50 BYTE); begin alter session disable guard; insert into AUDIT values ( user,adfg,sysdate); commit; alter session enable guard; end; end;
any help is appreciatedCode:SQL> show errors Errors for PROCEDURE PR_LOGACCESS: LINE/COL ERROR -------- ----------------------------------------------------------------- 8/4 PLS-00103: Encountered the symbol "ALTER" when expecting one of the following: begin case declare exit for goto if loop mod null pragma raise return select update while with<< close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe