I'm trying to use the dbms_job package & submitting my job using:
VAR jobno number;
this comes back with the error:
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.STANDARD", line 1014
ORA-06512: at line 1
what am I doing wrong?! any help would be much appreciated.
Looks like the exception is coming from the procedure. Your procedure seems to have a select statement that returns more than one row. If that is the case you might want to think of using cursor, to establish this query and resubmit it.
Life is a journey, not a destination!