NetConnection + Table As Parameter

neonomaly · Post by **neonomaly** » Thu 16 Jun 2011 10:31

Hello,

Is it possible to use tables/arrays as parameters for queries through Net(Direct) Connection in latest version of ODAC? If it is possible give example...

AlexP · Post by **AlexP** » Thu 16 Jun 2011 11:18

Hello,

Such Oracle types as OBJECT, ARRAY, REF, XML, BINARY_DOUBLE, BINARY_FLOAT are not supported in the Direct mode.
You can find more detailed information in the ODAC help, the Connecting in Direct Mode topic.
We plan to add the possibility of working with these types in the Direct mode in the future.

neonomaly · Post by **neonomaly** » Sun 19 Jun 2011 14:22

What minimal part of Oracle client should be installed for using ODAC through Client Connection Mode?

AlexP · Post by **AlexP** » Mon 20 Jun 2011 07:30

Hello,

You can use Oracle Instant Client that does not require installation and includes the minimal number of necessary files for working in the OCI mode (You can downloaad Oracle Instant Client at the Oracle official site).