On Sat, Dec 5, 2009 at 6:01 PM, Don Baccus <dhog...@pacifier.com> wrote: > On Dec 5, 2009, at 5:13 PM, Tom Jackson wrote: >> >> Tcl can write a query string which uses the keyword NULL. >> Unfortunately the simple (but very nice and also safe) bind variable >> concept doesn't handle this common requirement. > > You've got it backwards, it's the empty string, not NULL, which a bind > variable in Oracle (or in our emulation for postgres), doesn't handle - it > becomes NULL (this is true of the empty string in Oracle in general).
The "requirement" is the ability to handle both the empty string and NULL. Personally I like the Oracle behavior. tom jackson -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <lists...@listserv.aol.com> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.