Executing the Stored Procedure from SQL Plus

To execute the stored procedure:
  1. Launch a command window and run SQL Plus through the command line: e.g. C:\SQLPlus <username>/<password>@<SID>.
  2. Enter a user name and password.
  3. Log into the database as a schema owner.
  4. Enter the following: SQL> exec Expere_Admin.AnalyzeRepository();
The following will appear: PL/SQL procedure successfully completed.
WKFS