mauropagano/sqld360

Getting ORA-13618 error under STA link on main index page

Opened this issue · 0 comments

From the main index page, choose option 5H SQL Tuning Advisor txt.
The follow error messages repeat:

SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK('SYS_AUTO_SQL_TUNING_TASK','EXEC_36880')
ERROR:
ORA-13618: The specified value is not a valid value for procedure argument
TYPE.
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 8740
ORA-06512: at "SYS.DBMS_SQLTUNE", line 1052
ORA-06512: at line 1

The SELECT statement is properly generated but I've verified the error by running the SELECT via SYS user on the database in question.