OracleParameter eats prefix

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
MihaMarkic
Posts: 1
Joined: Fri 27 Jan 2012 20:23

OracleParameter eats prefix

Post by MihaMarkic » Fri 27 Jan 2012 20:28

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
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 31 Jan 2012 14:20

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;

Post Reply