PLS-00904: insufficient privilege to access object PUBLIC.DBMS_LOCK
DBA授权:
SQL> grant execute on sys.dbms_lock to jacob;
Grant succeeded.
---------------------------------------------------------------
ORA-01453: SET TRANSACTION must be first statement of transaction
set transaction isolation level 之前commit或rollback
DBA授权:
SQL> grant execute on sys.dbms_lock to jacob;
Grant succeeded.
---------------------------------------------------------------
ORA-01453: SET TRANSACTION must be first statement of transaction
set transaction isolation level 之前commit或rollback