in reply to Re^2: Inserting an empty string, not NULL, with $dbh->quote()
in thread Inserting an empty string, not NULL, with $dbh->quote()

Oracle also has the nasty habit of treating NULL and empty strings equally or converting one to the other -- not always, but always when you don't expect it.
With VARCHAR2 there is no "treating equally or converting".

An empty VARCHAR2-string IS a NULL - always.

  • Comment on Re^3: Inserting an empty string, not NULL, with $dbh->quote()

In Section Seekers of Perl Wisdom