Skip to Main Content

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!

Oracle 11.2.0.4 DeriveParameters not working with XMLType

user12018946Dec 4 2013 — edited Feb 18 2014

Hi folks, this has me stumped and can't find anyone talking about it.


We're using ODP (non-managed). 

Calling OracleCommandBuilder.DeriveParameters to get a parameter collection for SP that inserts a record into a table.

The table contains a Column of type XMLType.  The Insert SP contains a matching parameter of type XMLType.

When we call DeriveParameters on the OracleCommand set to the SP, we get the following error:

"Unsupported PL/SQL datatype at parameter position 3"   Note that position 3 identifies the XMLType param.

This is code that is working against an Oracle 11.2.0.3 install.

This error occurs in ODAC (11.2.0.3) and in ODAC 12 (latest).

One more odd part... if we build the parameters collection by hand, we can call the SP just fine and insert the records into the table.  Its really just a problem deriving it.

UPDATE-  Haven't heard any responses on this... double checked and this is a clean Oracle 11.2.0.4 install (all default options) on a clean Windows 2008 server.  We can't be the only ones using this configuration.  Nobody else has seen this?

This post has been answered by Alex Keh-Oracle on Dec 10 2013
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 18 2014
Added on Dec 4 2013
5 comments
3,295 views