Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Optional (ignored) parameters in stored procedures (PL/SQL)? How to?

Re: Optional (ignored) parameters in stored procedures (PL/SQL)? How to?

From: Kurta <submit_at_galleus.com>
Date: 10 Jan 2004 05:39:56 -0800
Message-ID: <efcb1994.0401100539.1a9c55e8@posting.google.com> 





I think this gives the same result as the COALESCE example. 



If the UMBS_OBJ_STT column contains NULL values those rows are not
returned. (NULL = NULL returns false) And we should receive all rows
when the state parameter is NULL.



"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:<qomdnesa_eAWQWOi4p2dnA_at_comcast.com>...


> OPEN resultCursor FOR

>      SELECT UMET_ID


>        FROM T_UM_BASE


>        WHERE UMBS_MEMB = memberId

>           AND  UMBS_OBJ_STT = nvl(state,UMBS_OBJ_STT)

> 

> -- mcs

Received on Sat Jan 10 2004 - 07:39:56 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US