Re: Passing parameters to PL/SQL Procedure

From: <private_comm_at_my-deja.com>
Date: Tue, 07 Dec 1999 20:54:25 GMT
Message-ID: <82js5v$rnu$1@nnrp1.deja.com>

In article <384c7bda$0$4328_at_fountain.mindlink.net>, "Tim Kang" <timkang_at_stratfordinternet.com> wrote:
> Hi
>
> I am trying to replace the value of a parameter with '%' if nothing is
> returned. However, I am not sure what value is assigned to the
parameter.
> I've tried to detect the value with LENGTH(). Also, I've checked to
see if
> the value is an empty string (i.e. ''). Neither of these methods
actually
> detects the passed parameter with no value.
>
> Thanks
>

Try defaulting your parameter to '%'.

e.g. CREATE OR REPLACE test (test_param IN VARCHAR2 DEFAULT '%');

PC
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 07 1999 - 14:54:25 CST