Skip to Main Content
Forums

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

kenS

Replying to Joe's question in an attempt to get it visible on the Overview tab.  Seems like this is the only post displayed in Content tab that isn't also on the Overview tab.

Is this a forum defect?

Alex Keh-Oracle

This sounds like a known issue: Bug 17389314. Oracle Support is working to debug it.

1 person found this helpful
user12018946

Thank you for the Response.  So we need to determine what to communicate to our customers re: Oracle DB versions that work with our product.  To make this decision we need to know a few things:

1) Will a fix to this be in ODP?

2) Will that fix cover all Oracle DB versions 10.2 and later?

3) If so, is there a timeline when it might be available?

Thank you for your assistance!


Alex Keh-Oracle
Answer

Since the bug hasn't been diagnosed yet, I can't answer any of these question definitively. My expectation would be yes to the first two questions, but it really depends on the bug's root cause.

Marked as Answer by user12018946 · Sep 27 2020
Tedper-Oracle

Hi,

A fix is now available for Bug 17389314.  If you are licensed for support for ODP, and if the current version of ODP which you are running is within its period of Premier Support, then you may now file a service request, asking that the fix be backported to your current version.

Sincerely,

Ted

Oracle Support Services

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

Post Details

Locked on Mar 18 2014
Added on Dec 4 2013
#odp-net
5 comments
3,302 views