Error: 'Enter Value for Lock' when running SQL scripts for VigilEnt Password Manager for Oracle. (NETIQKB30513)

fact
VigilEnt Password Manager for Oracle 5.0

fact
VigilEnt Password Manager for Oracle 6.x

fact
VigilEnt Security Agent for Oracle 1.x

symptom
Error: 'Enter Value for Lock' when running SQL scripts for VigilEnt Password Manager for Oracle.

symptom
Warning: Package Body Created with Compilation Errors.

symptom

Sample Error:

SQLCQR_PROD043>@c:\sqlcqr_PrivatePkg_Body_ORA8.sql
Enter value for lock:
Warning: Package Body created with compilation errors

cause
The main package SQL script for VigilEnt Password Manager for Oracle will produce this error when run using a tool called SQLPlus. This error occurs because the main package for VigilEnt Password Manager for Oracle is "wrapped" or "encrypted" for privacy and the SQLPlus tool cannot interpret a value found within the SQL script.

fix

Two generally accepted solutions to resolve this error message are:

• Change the SQLPlus parameter option, Define, to OFF.

  Or,

• Use the Oracle Server Manager tool to run the SQL script.

Formerly known as NETIQKB30513