Re: Oracle NULL vs '' revisited

From: Matthew Harrison <m.harrisson_at_craznar.com>
Date: Sat, 18 Aug 2007 12:06:00 +1000
Message-ID: <13ccl17b3h4u8d0@corp.supernews.com>

zigzagdna_at_yahoo.com wrote:

>It has always worked for me. Oracle may have messed up

> things but if a disciplined approach by keeping null indicator
> separate from the actual value is followed all through the code,
> things will still work.

So , I have a stored proc with a parameter MSG.

I have a table with values MSG and MSGISNULL.

How do I tell the parameter is '' or NULL ?

Or does the client user have to pass two parameters and do the test in their own langauge.

The catch here is that if it was a number, I just wouldn't put a value in ... that is ... the stored procedure would not have been called.

So - how do I detect, and act on someone NOT calling the stored procedure and set a flag ?

-- 
Pinging self [127.0.0.1] with 32 bites of banana cake:

Ping statistics for 127.0.0.1:
     Slices: Sent = 4, Received = 0, Lost = 4 (100% loss),

Received on Fri Aug 17 2007 - 21:06:00 CDT