Re: Oracle NULL vs '' revisited

From: Gumby! <localhost_at_gumby.com>
Date: Sat, 18 Aug 2007 09:14:37 GMT
Message-ID: <1Myxi.22551$4A1.5148@news-server.bigpond.net.au>

zigzagdna_at_yahoo.com wrote:

> Not sure I fully undesratnd , but I would think that client code has
> to pass two paremetrs, one indicating whethere value is null or not ,
> and the other the actaul value. You may even consiser an indicator
> column in the table for this varchar2 column, so you can look at the
> value of the indicator column to decide whther " msg is not null.
>

The point is - if the client is calling the procedure, then the message will not be null (but could be '').

That is - it's the uncalled messages are the problem ... I'd have to create a flag for all of them saying with a bit mask of null flags. Received on Sat Aug 18 2007 - 04:14:37 CDT