ORA-20402 error generating SQLT output using XECUTE method.
I have a customer who is trying to generate SQLT for a query and is getting the following error:
BEGIN sqltxplain.sqlt$i.xecute_end(p_statement_id => :v_statement_id, p_string => 'sqlt_s'||:v_statement_id, p_sql_id => '', p_child_number => ' ', p_input_filename => 'input/sample/Q110.sql', p_password => 'Y'); END;
*
ERROR at line 1:
ORA-20402: unique_id "" or statement_id "97885" are null
ORA-06512: at "SQLTXPLAIN.SQLT$D", line 152
ORA-06512: at "SQLTXPLAIN.SQLT$D", line 401
ORA-06512: at "SQLTXPLAIN.SQLT$I", line 2084
ORA-06512: at line 1
Anyone seen this before or know what might cause it?
BEGIN sqltxplain.sqlt$i.xecute_end(p_statement_id => :v_statement_id, p_string => 'sqlt_s'||:v_statement_id, p_sql_id => '', p_child_number => ' ', p_input_filename => 'input/sample/Q110.sql', p_password => 'Y'); END;
*
ERROR at line 1:
ORA-20402: unique_id "" or statement_id "97885" are null
ORA-06512: at "SQLTXPLAIN.SQLT$D", line 152
ORA-06512: at "SQLTXPLAIN.SQLT$D", line 401
ORA-06512: at "SQLTXPLAIN.SQLT$I", line 2084
ORA-06512: at line 1
Anyone seen this before or know what might cause it?
0