SQL> create or replace procedure logexecution is
2 begin
3 insert into logtable(userid,logdate) values(user,sysdate);
4 end;
5 /
Warning: Procedure created with compilation errors.
SQL> create or replace procedure logexecution is
2 begin
3 insert into logtable(userid,logdate) values(user,sysdate);
4 end;
5 /
Warning: Procedure created with compilation errors.
SQL> exec logexecution;
BEGIN logexecution; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object SCOTT.LOGEXECUTION is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored