-
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.
-
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.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|