Hi,
I'm trying to use the dbms_job package & submitting my job using:
VAR jobno number;
exec dbms_job.submit(:jobno,'proc_sort_area_hit_ratio;',sysdate,'sysdate+(1/1440)*60');
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.