OracleParameter eats prefix

[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").

[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;