Subprogram Information in the Oracle Data Dictionary - Exercise

Contact Us or call 1-877-932-8228
Subprogram Information in the Oracle Data Dictionary - Exercise

Subprogram Information in the Oracle Data Dictionary

Duration: 10 to 15 minutes.
  1. Create the procedure by executing the script in the Demo below.
  2. Locate general information in the Oracle Data Dictionary about the procedure (as well as SQL Developer).
  3. Display the Source Code using the Data Dictionary (as well as SQL Developer).
  4. Remove the trailing semicolon following the NULL statement from the procedure and compile the procedure again.
  5. Look at the results in user source (and notice that the change is reflected here).
  6. Retrieve error information from the Oracle Data Dictionary using a query (and notice where the error shows up in SQL Developer). Determine the status of the object by looking at USER_OBJECTS.
  7. Add the trailing semicolon following the NULL statement from the procedure and compile the procedure again (it should be valid now). Check the status of the object in USER_OBJECTS.

Code Sample:

Introducing-Subprograms/Exercises/a_simple_subprogram.sql
create or replace procedure a_simple_subprogram
is
begin
   null;
end;
/

Code Explanation

Solution:

Introducing-Subprograms/Solutions/introducing_subprograms_solution.sql
            

Code Explanation

Next