Resolution
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
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
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.
Additional Information
Formerly known as NETIQKB30513