I'm trying to test stored procedure's. When I create my database I'm using a script from the ventor which should create some stored procedures. When I try to view the stored procedures using (select job, what from dba_jobs;) I don't see one of the stored procedure. So I would like to create a dummy stored procedure. I used this procedures

SQL> CREATE PROCEDURE remove_job (job_id NUMBER) as
2 tot_job NUMBER;
3 begin
4 delete from sysman.mgmt_user_jobs
5 where sysman.mgmt_user_jobs.job_id = remove_job.job_id;
6 tot_job := tot_job -1;
7 end;
8 /

Then when I run (select job, what from dba_jobs;) I don't see the procedure.

Can someone tell me what I am doing wrong?

Thanks

Wolf

Oracle LazyDBA home page