note 42276 deleted from function.ocifetchinto by sixd

Note Submitter: McKay Salisbury ---- test1 said that it has to be in all caps, but that isn't the case. Oracle is case sensitive, but it has weird case sensitivity behavior. oracle takes all identifiers, and "To_Upper"s them, unless they are in double quotes, which it treats as exact case (Single quotes are used for string delimiters) then a table with the name "BLAH" having columns "Blah1", "BLAH2", and "BLAH3" could be accessed by the SQL statement select "Blah1", blah2, "BLAH3" from bLaH; which is the same as select "Blah1", "BLAH2", bLaH3 from blah; (note that there is only one way to reference something that is stored in mixed or lower case, i.e. in its proper case, with strings around it so if a table is created with mixed case and double quotes, then that's how they'll come out of the orifetchinto statement and they will not be all upper case, but most of the time Oracle DBAs (especially dba's recently transferred from a different DBMS) tend to leave the double quotes off all the time, and it appears as if oracle is case insensitive.