Solved

dbms_job.submit using jdbc

Posted on 2004-09-14
5
883 Views
Last Modified: 2008-03-17
I have a jsp from which I am submitting the oracle procedure name, which is being used to submit as the oracle job.

I am using the CallableStatement to call DBMS_JOB.SUBMIT to schedule the procedure.

But when I execute the JSP, I am getting the following error

Error while submiting the job=>ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_JOB", line 142

Need help.


0
Comment
Question by:kulsmadya
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 35

Accepted Solution

by:
TimYates earned 500 total points
ID: 12053925
0
 
LVL 35

Expert Comment

by:TimYates
ID: 12053933
There's something wrong with your stored procedure...  That link should help :-)
0
 
LVL 11

Expert Comment

by:sompol_kiatkamolchai
ID: 12055147
Can you run that store procedure manually in SQL editor?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
Configuring Remote Assistance for use with SCCM
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decadeā€¦

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question