PL/SQL issues
Tuesday, 24. April 2007, 04:15:09
when loading procedure/function,
SQL> CREATE OR REPLACE PROCEDURE compute_intensive_program
Warning: Procedure created with compilation errors.
SQL> SHOW ERRORS -- show the details of error message
if Oracle reports ``error PLS-00103'', you should type:
oerr PLS 00103
when error "PLS-00201: identifier 'DBMS_LOCK' must be declared" occurs, you may grant privilege to the specific user/public.
SQL> grant execute on dbms_lock to luser; -- schema who owns procedure
or
SQL> grant execute on dbms_lock to public;
相关链接：
http://w2.syronex.com/jmr/edu/db/introduction-to-plsql/
http://www.oracle.com/technology/oramag/oracle/06-jul/o46plsql.html
http://www.orafaq.com/forum/t/65567/0/
SQL> CREATE OR REPLACE PROCEDURE compute_intensive_program
Warning: Procedure created with compilation errors.
SQL> SHOW ERRORS -- show the details of error message
if Oracle reports ``error PLS-00103'', you should type:
oerr PLS 00103
when error "PLS-00201: identifier 'DBMS_LOCK' must be declared" occurs, you may grant privilege to the specific user/public.
SQL> grant execute on dbms_lock to luser; -- schema who owns procedure
or
SQL> grant execute on dbms_lock to public;
相关链接：
http://w2.syronex.com/jmr/edu/db/introduction-to-plsql/
http://www.oracle.com/technology/oramag/oracle/06-jul/o46plsql.html
http://www.orafaq.com/forum/t/65567/0/
WIDGETIZE