Home » Unlabelled » Suppose a procedure is created using the CREATE PROCEDURE command; however, it gives a syntax error. Which data dictionary views will have the source code of the procedure? | PL SQL
Saturday, 26 May 2012
Suppose a procedure is created using the CREATE PROCEDURE command; however, it gives a syntax error. Which data dictionary views will have the source code of the procedure? | PL SQL
The USER_SOURCE, ALL_SOURCE, and DBA_SOURCE data dictionary views will have the source code, as a procedure is stored in the database even if it has a syntax error.
No comments:
Post a Comment