'run_addm' error

From: <jackzhunj_at_gmail.com>
Date: Fri, 4 Apr 2008 08:08:37 -0700 (PDT)
Message-ID: <58cc3b85-0d03-4983-973d-f5217731c1f9@a23g2000hsc.googlegroups.com>

Oracle 10.2.0.3

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! Received on Fri Apr 04 2008 - 10:08:37 CDT