Re: Select Into doesn't work properly

From: Daniel <delj_at_flash.net>
Date: Wed, 12 Jan 2000 08:44:08 GMT
Message-ID: <s9Xe4.1748$ro4.178276@news.flash.net>

Use a cursor. You will then be able to trap for both the condition where multiple rows are returned and when the query returns no rows.

Daniel
Austin, TX

"Dirk his Linux bakje" <d.joosen_at_planetinternet.nl> wrote in message news:387C3429.C099DE6A_at_planetinternet.nl...
> Hi
>
> I have a problem with a stored procedure where I declared an Select Into
> statement like:
> l_num NUMBER;
> SELECT ID_1 INTO l_num FROM TABLE WHERE ID_2 = INPUT_PARAMETER;
> This occurs in a ORA-01422: exact fetch returns more than requested
> number of rows.
>
> When I type in PL/SQL the statement:
> SELECT ID_1 FROM TABLE WHERE ID_2 = INPUT_PARAMETER;
> Then the PL/SQL says: no rows selected
> You see PL/SQL has no problems.
>
> What do I wrong,?
> Thanks and with best regards
> Dirk Joosen
>
>
Received on Wed Jan 12 2000 - 02:44:08 CST