note 35939 added to function.ocidefinebyname

>Be careful that Oracle uses ALL-UPPERCASE column-names, That is actually untrue. Oracle defaults to all uppercase names, *unless* the COLUMN is CREATEd in quotes, in which case, case is preserved, and the exact case passed much match, which means anything other than uppercase COLUMN names must be sent in quotes. For example CREATE TABLE A ("a" NUMBER, a NUMBER); The first COLUMN stays lowercase, the second becomes uppercase. As another example, CREATE TABLE A ("a" NUMBER); INSERT INTO A VALUES(1); SELECT a FROM A; SELECT "a" FROM A; The first SELECT will fail, because it defaults to uppercase which will *not* match the lowercase COLUMN name. ---- Manual Page -- http://www.php.net/manual/en/function.ocidefinebyname.php Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+35939 Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+35939&report=yes Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+35939&report=yes