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 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?!?


Log in to reply
 

Looks like your connection to What the Daily WTF? was lost, please wait while we try to reconnect.