Wolf

The procedures are stored in dba_source.

Good luck

Chris

-----Original Message-----
From: Wolf Schwurack
[mailto:oracledba-ezmlmshield-x49563112.[Email address protected]
Sent: Wednesday, April 04, 2007 11:03 AM
To: LazyDBA Discussion
Subject: Create Procedure

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


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




This message (including any attachments) is confidential and intended solely for the use of the individual or entity to whom it is addressed, and is protected by law. If you are not the intended recipient, please delete the message (including any attachments) and notify the originator that you received the message in error. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Vanguard Health Systems.

Oracle LazyDBA home page