Oracle ODP Provider and DeriveParameters

[rpbinphilly]

Hi All,
I've been looking int adding support for the Oracle ODP into an
application. The problem is that the
OracleCommandBuilder.DeriveParameters method isn't supported. I would
have thought that this would be considered indispensable, but... guess
not.

Automatic parameter discovery is an important feature - does anyone
have a suggestion as to how this can be done via ODP?

Thanks very much in advance.

rpb

 

[Frans Bouma [C# MVP]]

Hi All,
I've been looking int adding support for the Oracle ODP into an
application. The problem is that the
OracleCommandBuilder.DeriveParameters method isn't supported. I would
have thought that this would be considered indispensable, but... guess
not.

Automatic parameter discovery is an important feature - does anyone
have a suggestion as to how this can be done via ODP?

Which ODP.NET version are you using with which Oracle version? Because
in 10g's ODP.NET for example, it's supported, though only for
procedures, not for anonymous PL/SQL blocks.

FB

--