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.