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 18.104.22.168 install.
This error occurs in ODAC (22.214.171.124) 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 126.96.36.199 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?
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!
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.
Oracle Support Services