• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 896
  • Last Modified:

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.


0
kulsmadya
Asked:
kulsmadya
  • 2
1 Solution
 
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

Featured Post

Industry Leaders: 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!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now