Home » SQL & PL/SQL » SQL & PL/SQL » Problem with dbms_scheduler (merged)
Problem with dbms_scheduler (merged) [message #420871] Wed, 02 September 2009 17:47 Go to next message
Draco
Messages: 6
Registered: March 2006
Location: Germany/Duesseldorf
Junior Member
Hi all Wink

I have a Problem with the program arguments.


./fa/6741/0/


I canĀ“t understand why i get the exeptions. The code for the procedure, program and program_argument seems to be right.

Thanks in advance Wink
Re: Problem with dbms_scheduler [message #420873 is a reply to message #420871] Wed, 02 September 2009 17:58 Go to previous messageGo to next message
BlackSwan
Messages: 24907
Registered: January 2009
Senior Member
>The code for the procedure, program and program_argument seems to be right.
Oracle & error codes seem to disagree with the statement above.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.


Too bad for all concerned that CUT & PASTE are broken for you.
Re: Problem with dbms_scheduler [message #420874 is a reply to message #420871] Wed, 02 September 2009 19:02 Go to previous messageGo to next message
ThomasG
Messages: 3185
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
On first glance, "repeat_interval" shouldn't be in "create_program", it should be in "create_schedule" or "create_job".

See the examples here.

Re: Problem with dbms_scheduler (merged) [message #420884 is a reply to message #420871] Thu, 03 September 2009 00:42 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If you do a describe of dbms_scheduler, you can see the arguments each procedure accepts (and expects).
You use some arguments that are not correct for the given procedures.
Adding emphasis to certain areas of your "problem description" (the red boxes in your screenshot) gives other readers the idea that those areas are the pieces causing the problem. Unless you KNOW what causes the problem, you should not add such emphasis to random areas.
Previous Topic: How to access Subversion (SVN) from PL/SQL
Next Topic: Need a Query to solve this
Goto Forum:
  


Current Time: Tue Sep 27 11:06:36 CDT 2016

Total time taken to generate the page: 0.11235 seconds