ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Order of parameters

521751Jul 6 2006 — edited Jul 25 2006

Hi,

When you using parametrized queries like eg. INSERT INTO DEPT (DNAME, LOC, DEPTNO) VALUES (:DNAME, :LOC, :DEPTNO)

You apperently have to add the parametres objects for each placeholder in the exact same order as stated in de query

I thought this was only needed in ODBC or OLEDb providers

Is this by design or a a bug ?

Regards,

ps: By the way the Microsoft managed .NET Oracle Data provider does not expect the correct order.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2006

Added on Jul 6 2006

#odp-net

4 comments

868 views