M
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 example
CMD.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?!?