dbms_job.submit using jdbc

Posted on 2004-09-14
Medium Priority
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.

Question by:kulsmadya
  • 2
LVL 35

Accepted Solution

TimYates earned 2000 total points
ID: 12053925
LVL 35

Expert Comment

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

Expert Comment

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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Are you in the migration process of your Exchange to Exchange Online? Be aware of customized solutions developed on the transport role on your old Exchange server. They might not be convertible to Exchange Online!
Migrating Exchange data from one Exchange Server to another server is complicated. Though Exchange administrators can try manual methods to migrate their data from one version of Exchange to another, these manual methods are not that reliable. That…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

587 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