DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dbms_job

  1. #1
    Join Date
    Jan 2001
    Posts
    10

    Unhappy

    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.


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  3. #3
    Join Date
    Jan 2001
    Posts
    10
    thanks,

    Gareth

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width