When I run the following script as sys:
SET PAGESIZE 0 LONG 1000000 LONGCHUNKSIZE 1000;
COLUMN get_clob FORMAT a80;
-- execute run_addm() with 7pm and 9pm as input
VARIABLE task_name VARCHAR2(30);
BEGIN
:task_name := run_addm( TO_DATE('18:00:00 (04/03)', 'HH24:MI:SS (MM/
DD)'),
TO_DATE('20:00:00 (04/03)', 'HH24:MI:SS (MM/
DD)') );
END;
/
-- execute GET_TASK_REPORT to get the textual ADDM report.
SELECT DBMS_ADVISOR.GET_TASK_REPORT(:task_name)
FROM DBA_ADVISOR_TASKS t
WHERE t.task_name = :task_name
AND t.owner = SYS_CONTEXT( 'userenv', 'session_user' );
I got the following error:
SQL>
:task_name := run_addm( TO_DATE('18:00:00 (04/03)', 'HH24:MI:SS (MM/
DD)'),
*
ERROR at line 2:
ORA-06550: line 2, column 17:
PLS-00201: identifier 'RUN_ADDM' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
no rows selected
I find out 'run_addm' function doesn't exist in sys schema. Should I
run any scripts to create the necessary objects?
Thanks a lot!