ORA-01422 Error when on procedure execution
From: Sunil Tiwari <tiwari_p_at_infy.com>
Date: 29 Jun 2001 04:17:25 -0700
Message-ID: <73c6284.0106290317.3e429a3f_at_posting.google.com>
CREATE OR REPLACE PROCEDURE AP_COMPANY_TRANSACTION (POID IN NUMBER , NAME OUT VARCHAR2) IS BEGIN
SELECT distinct(COMPANY_PROFILE.COMPANY_NM) INTO NAME FROM COMPANY_PROFILE, VW_PO_HEADER
WHERE VW_PO_HEADER.BUYER_COMPANY_ID = COMPANY_PROFILE.COMPANY_ID AND VW_PO_HEADER.PO_ID = POID;
END;
This is how i have called it
Declare
name varchar2(40);
begin
AP_COMPANY_TRANSACTION(1001,NAME);
end;
Date: 29 Jun 2001 04:17:25 -0700
Message-ID: <73c6284.0106290317.3e429a3f_at_posting.google.com>
Hi ,
I am getting the error as
ORA-01422 EXACT FETCH RETURNS MORE THAN REQUESTED NUMBER OF ROWS.
This is my procedure
CREATE OR REPLACE PROCEDURE AP_COMPANY_TRANSACTION (POID IN NUMBER , NAME OUT VARCHAR2) IS BEGIN
SELECT distinct(COMPANY_PROFILE.COMPANY_NM) INTO NAME FROM COMPANY_PROFILE, VW_PO_HEADER
WHERE VW_PO_HEADER.BUYER_COMPANY_ID = COMPANY_PROFILE.COMPANY_ID AND VW_PO_HEADER.PO_ID = POID;
END;
This is how i have called it
Declare
name varchar2(40);
begin
AP_COMPANY_TRANSACTION(1001,NAME);
end;
The SQL query returns one and only one row always
Advice needed from experts
Sunil Received on Fri Jun 29 2001 - 13:17:25 CEST