Page 1 of 1

OracleParameter eats prefix

Posted: Fri 27 Jan 2012 20:28
by MihaMarkic
Hi there,

Is it possible to preserver the original parameter name?
If I do this

Code: Select all

OracleParameter p = new OracleParameter();
p.ParameterName = ":p1";

string name = p.ParameterName;
I get "p1" and not ":p1" as I'd expect.

Update: Looks like using double colons does the trick ("::p1").

Posted: Tue 31 Jan 2012 14:20
by Shalex
Please set the OracleUtils.OracleClientCompatible property to True like

Code: Select all

    OracleUtils.OracleClientCompatible = true;
    OracleParameter p = new OracleParameter();
    p.ParameterName = ":p1";

    string name = p.ParameterName;