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

  • 7730513
  • 02-Feb-2007
  • 14-Aug-2007

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

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