Re: ORA-01422 Error when on procedure execution
Date: Mon, 2 Jul 2001 08:49:29 +0800
Message-ID: <3b3fc5dc.0_at_news2.tm.net.my>
hi sunil,
when u r selecting INTO a variable, ur select statement can return only a single row.... so ensure that ur select statement i.e.
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;
returns only one row....
hope this helps
regards,
aparna
"Sunil Tiwari" <tiwari_p_at_infy.com> wrote in message
news: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 Mon Jul 02 2001 - 02:49:29 CEST