BINDBYNAME false by default?
-
Ok, yes, it's fairly simple to correct but WHY would anyone implement it that way.
Using the ODP and I have some parameterized commands, and I give the parameters names. For a reason.
So, for exampleCMD.COMMANDTEXT = "SELECT FOO FROM BAR WHERE BAR.FIELD1 = :PARAM1 and BAR.FIELD2 = :PARAM2"
CMD.PARAMETERS.ADD ("PARAM2", VALUE2)
CMD.PARAMETERS.ADD("PARAM1",VALUE1)
Gets processed as "SELECT FOO FROM BAR WHERE BAR.FIELD1 = VALUE2 and BAR.FIELD2 = VALUE1"
UNLESS I add CMD.BINDBYNAME = TRUE.If I wanted Oracle to just stick the values wherever it felt like it, I would not have named my parameters!!!
Should the default for BINDBYNAME not be FALSE?!?