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