+ Reply to Thread
Results 1 to 6 of 6
  1. 02-27-2002 12:12 PM #1
    gaegoori
    gaegoori is offline Member
    Join Date
    Jun 2001
    Posts
    243
    I'm getting following error messages..what should I look for?


    ORA-01422: exact fetch returns more than requested number of rows
    ORA-06512: at "RPIDB.RPI_MISC", line 690
    ORA-06512: at "RPIDB.RPI_ARMY", line 393
    ORA-06512: at line 20


    both RPI_MISC and RPI_ARMY are Procedures...

    Thanks.
    Reply With Quote Reply With Quote
  2. 02-27-2002 12:41 PM #2
    balajiyes
    balajiyes is offline Advisor
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    hi,
    i think u r using some select *** into lv_var from table_name;
    here is the problem

    i think i hv helped u
    thnx,
    Cheers!
    OraKid.
    Reply With Quote Reply With Quote
  3. 02-27-2002 01:06 PM #3
    gaegoori
    gaegoori is offline Member
    Join Date
    Jun 2001
    Posts
    243
    yes..I'm using select...into......
    what's my option to solve this problem?
    Reply With Quote Reply With Quote
  4. 02-27-2002 01:52 PM #4
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline mod
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,844
    write a query that returns one row. you can do this by running the query in SQLPlus without the into part of the query and see how many rows are returned. You can also add the distinct word to the clause.

    If you need further help post the query.
    Reply With Quote Reply With Quote
  5. 02-27-2002 03:28 PM #5
    Mnemonical
    Mnemonical is offline Senior Member
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282

    Use a Cursor.

    DECLARE
    CURSOR cursor_name IS Select ... ;
    var1 ...
    var2 ...

    BEGIN
    OPEN cursor_name;
    LOOP
    FETCH cursor_name INTO var1, var2, ....
    .
    .
    .
    END LOOP;
    CLOSE cursor_name;
    END;


    F.



    Reply With Quote Reply With Quote
  6. 03-01-2002 06:04 AM #6
    sri_garige
    sri_garige is offline Junior Member
    Join Date
    Dec 2000
    Posts
    23
    generally that error occurs due to the select statement returns more than one value.
    means if u issue SELECT INTO from ...............
    so every variable can hold only one value at a time.
    so that if that select statment returns more than one value, then system doesn't understood which value should be stored in that variable.
    thats why the error occured.
    so u can try that using
    SELECT DISTINCT INTO from
    ...............
    or using cursors.

    Vth pleasure...
    Bhaskar Akkala.............
    sridhar garige
    Reply With Quote Reply With Quote
    « Previous Thread | Next Thread »

    Bookmarks

    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