Re: Select into difficulties

>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

It's very simple
Begin NEW_PROD_ID_OUT := PROD_ID_IN;
  SELECT ............. If no data is found NEW_PROD_ID_OUT will retain the value assigned to it.

John   Received on Fri Jan 16 1998 - 00:00:00 CST