Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

'run_addm' error

0 views
Skip to first unread message

jack...@gmail.com

unread,
Apr 4, 2008, 11:08:37 AM4/4/08
to
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!

0 new messages