Getting PLS-00222: no function with name
155248Feb 13 2007 — edited Feb 13 2007I'm learning to use dbms_scheduler.
I've created a simple pl/sql procedure and am calling it from the dbms_scheduler command.
When I run dbms_scheduler I get this: ORA-06550: line 5, column 31: PLS-00222: no function with name 'INSERT_STATUS_TEST' exists in this scope
Here's the pl/sql procedure:
create or replace procedure "INSERT_STATUS_TEST"
is
begin
INSERT INTO schedule_test (schedule_dt) VALUES (sysdate);
commit;
end;
Here's the script with the dbms_scheduler call:
begin
dbms_scheduler.create_job
( job_name => 'D_1'
,job_type => 'STORED_PROCEDURE'
,job_action=> INSERT_STATUS_TEST
,repeat_interval => 'FREQ=MINUTELY;INTERVAL=1'
,enabled=>true
,auto_drop=>false
,comments=>'Test' );
end;
Can anyone tell from this what I'm doing wrong?
Thanks.
-- David