Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting PLS-00222: no function with name

155248Feb 13 2007 — edited Feb 13 2007
I'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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2007
Added on Feb 13 2007
11 comments
3,255 views