How ODAC with Net option to true communicate with Oracle DataBase ?
I know it by tcp-ip, but is it use some oracle backdoor or somethings like that ?
Oracle knows that you bypass is oracle client ?
Is it certify that Oracle will continue supporting this way to do ?
What happens if Oracle close the door you use to communicate ?
Is it more secure to use Oracle client on client machine ?
All these questions is to secure our technician that will support our application. Otherwise, they will force us to communicate with Oracle client and we're going to lose some performance.
Net option vs Oracle client (secure ?)
When the Net option is set to True, ODAC uses the same interface to communicate with Oracle database as Oracle client uses. If Oracle stops support this interface, both the current version of the Oracle client and ODAC become unable to work with the server.
Note that the Net option has limitations. There are some of them:
- Some types are not available, like OBJECT, ARRAY, REF, XML, BINARY_DOUBLE, BINARY_FLOAT.
- Multithreaded applications can be less stable when using the Net option.
You can see the list of the Net option limitations in the ODAC help (the 'Working with ODAC Net' article).
Note that the Net option has limitations. There are some of them:
- Some types are not available, like OBJECT, ARRAY, REF, XML, BINARY_DOUBLE, BINARY_FLOAT.
- Multithreaded applications can be less stable when using the Net option.
You can see the list of the Net option limitations in the ODAC help (the 'Working with ODAC Net' article).