-
Title
Error "ORA-06550 ... XPERT_TRACE_FILE_IO.VALIDATE must be declared" when running Trace Setup. -
Description
User opens SQL Optimizer and clicks on Options | Trace Setup, selects the connection to use, clicks on UTL File Access method and user sees all the fields disabled underneath. User then clicks Run Trace wizard, selects UTL file and clicks on Install package. The following error is displayed:
"ORA-06550 On line 1... XPERT_TRACE_FILE_IO.VALIDATE must be declared" -
Cause
Optimizer tries to create package 'XPERT_TRACE_FILE_IO'. Either the user for which the connection was selected does not have access to this package, or is unable to create this package.
-
Resolution
The following file can be run outside SQL Optimizer to create the required package.
C:\Program Files\Quest Software\Quest SQL Optimizer for Oracle\TraceSetupInstall.sql
Review the script as synonyms are also created.