Errors while running SQLT (XTRACT method)
Hi,
I am getting the errors while running sqlt (XTRACT method):
sqlt$a: *** i:"EXPLAIN PLAN FOR" this SQL errored out when executed connected as "ARWACPT". Always execute SQLT connected as the application user.
sqlt$a: *** i:ORA-00905: missing keyword
The tool was executed under the correct ID:
4 SQL>SELECT USER FROM DUAL;
5 USER
6 ------------------------------
7 ARWACPT
It looks like the error originates in install/sqcpkgi.pkb file:
BEGIN
l_error := NULL;
l_string := 'EXPLAIN PLAN SET statement_id = '''||sqlt$a.get_statement_id_c(p_statement_id)||''' INTO &&tool_repository_schema..sqlt$_sql_plan_table FOR';
l_sqltext := SYS.DBMS_LOB.SUBSTR(sql_rec.sql_text_clob_stripped); -- first up to 32666 characters