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.