Unable to see SQL ERROR HOST VARIABLES

Document ID : KB000050766
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Collection options are setup as follow:

SQL collection options:
Standard Activity ==> Y (Y/N)
Dynamic SQL Stats ==> N (Y/N) (Requires profile)
View By Keys ==> N (Y/N) (Requires profile)
Dynamic Exceptions ==> Y (Y/N) (Requires profile)
Static Exceptions ==> N (Y/N) Exception cache size ==> 4000
SQL Errors ==> Y (Y/N) (Requires profile)
SQL Error Text ==> N (Y/N)
Host variables ==> Y (Y/N) (applies to all options)

But can't display the host variables for SQL error. What's wrong.

Solution:

To display SQL error Host variables, the SQL Error Text flag needs to be turned on. Without it the host variables will not display even though the Host variables flag is on.

For the Modify command, the parm to turn on SQL Error Text collection is SQT(Y).