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