dbms_job.submit using jdbc

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.


kulsmadyaAsked:
Who is Participating?
 
TimYatesCommented:
There's something wrong with your stored procedure...  That link should help :-)
0
 
sompol_kiatkamolchaiCommented:
Can you run that store procedure manually in SQL editor?
0
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.

All Courses

From novice to tech pro — start learning today.