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

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

From: Kurta <submit_at_galleus.com>
Date: 10 Jan 2004 05:42:23 -0800
Message-ID: <efcb1994.0401100542.4ecb3c9b@posting.google.com>

Thanks guys, I think native dynamic SQL will be the solution.

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1073667968.166471_at_yasure>...
> Niall Litchfield wrote:
>
> > How about overloading your function
> >
> > eg
> >
> > Function doit(memberid in T_UM_BASE.UMBS_MEMB%TYPE, state in
> > T_UM_BASE.UMBS_MEMB%TYPE);
> > Function doit(memberid in T_UM_BASE.UMBS_MEMB%TYPE);
> >
> > with appropriate selects in each one.
> >
>
> Or using native dynamic SQL?
>
> Though I do like overloading.
Received on Sat Jan 10 2004 - 07:42:23 CST