Re: Passing parameters to PL/SQL Procedure

From: JOC <oconnorj_at_freenet.co.uk>
Date: Tue, 07 Dec 1999 12:04:55 GMT
Message-ID: <384cf7ce.10645618@NEWS>

On Mon, 6 Dec 1999 19:14:00 -0800, "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 nvl

i.e. nvl(parameter, '%')

The usual - anything I say reflects on me, and not upon my current employer.

Received on Tue Dec 07 1999 - 06:04:55 CST