Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: ORA-01422: exact fetch returns more than requested number of rows

    I tried writing a simple PL/SQL query to force a ORA-01422 error. I do not understand why it is doing this. I would really appreciate some advise coz i'm new to pl/sql


    create or replace procedure pro_ins_ord as
    value number;
    begin
    -- i believe this is the line that is giving me the problem
    select s_customer_id.nextval into value from s_customer; dbms_output.put_line(value);
    end;
    /
    SHOW ERRORS;
    begin
    pro_ins_ord;
    end;
    /

    -------------------OUTPUT--------------


    SQL> @q5

    Procedure created.

    No errors.
    Input truncated to 1 characters
    begin
    *
    ERROR at line 1:
    ORA-01422: exact fetch returns more than requested number of rows
    ORA-06512: at "PATHROSS.PRO_INS_ORD", line 4
    ORA-06512: at line 2

    ----------------------------
    Attached Files Attached Files
    • File Type: sql q5.sql (207 Bytes, 120 views)

  2. #2
    Join Date
    Nov 2003
    Posts
    2

    I KNOW THE ANSWER. THANX, NO NEED TO REPLY

    NO NEED TO REPLY. THANX.

Posting Permissions

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