Solved

dbms_job.submit using jdbc

Posted on 2004-09-14
5
869 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
JSP call a method on a session attribute which is an object 2 61
java beans and EJBs 5 185
withoutString  challenge 40 178
Suggestion on WebSite Template Sites 6 81
If your vDisk VHD file gets deleted from the image store accidentally or on purpose, you won't be able to remove the vDisk from the PVS console. There is a known workaround that is solid.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now