Preparing to use PL/SQL utilities
A few things you need to know about running the utilities:
Any time that you are passing a string value as a parameter, the value must be contained within single quotes. For example:
Some functions require that you pass a group_id. To obtain this value, go to
Also, the PL/SQL utilities have functions that need to be executed from within a PL/SQL session, so set up your environment before you begin to use the utilities.
To prepare your SQL environment
- Start the sqlplus session. If any error messages appear, resolve these errors before you continue:
If your database server is on a Linux system, log in as the Linux user aptare.
If your database is on a Windows system, log in as a user who is a member of the ORA_DBA group and open a command prompt window.
sqlplus portal/<portal_password>@//localhost:1521/scdb
- Enable server output in PL/SQL:
SET SERVEROUTPUT ON