Re: Select into difficulties

SELECT nvl( MATCH_PROD_ID, -1) INTO...

Daniel Askey

Laura Bellini wrote:

> Hi.
>
> I am trying to populate a variable via a simple SELECT INTO statement.
> But, if the SELECT INTO returns no rows, I want to populate the variable
> with something else and continue the procedure. I DO NOT want to
> exception-out of the proc. Here is the statement w/in my proc:
>
> SELECT MATCH_PROD_ID
> INTO NEW_PROD_ID_OUT
> FROM PRODUCT_UP-CROSS_SELL
> WHERE PRODUCT_UP-CROSS_SELL.BASE_PROD_ID = PROD_ID_IN
> AND PRODUCT_UP_CROSS_SELL.MATCH_TYPE = 'U'
>
> PROD_ID_IN is an incoming parameter.
> If the above returns no rows, I just want to populate NEW_PROD_ID_OUT with
> PROD_ID_IN.
>
> Very simple, I think, but I'm unable to determine a way of doing it.
>
> thanks in advance.
>
> Laura Bellini
> laura_bellini_at_compaq.com
Received on Wed Jan 14 1998 - 00:00:00 CST