-
procedure not compiling
i am writing simple procedure but its erroring out due to alter
this is on logical standby
Code:
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;
it throws the following error
any help is appreciated
-
you are using sqlplus commands in plsql, cant do that unless you use execute immaediate
-
thank you ..appreciate your time