-
Title
Direct Connect gives "This type of connection does not support advanced object types" message. -
Description
When using direct connect to connect to a database, the following message is given.
“You are making a Direct Connection to Oracle using TCP/IP.
This type of connection does not support advanced object types such as nested tables, user defined objects, cross-connection queries, etc. You may also experience performance issues.
If possible we suggest using Oracle’s instant client. If you want to use cross-connection queries with an instant client you will need to install the ODBC driver also.”
What does this mean and what do I have to do to get rid of this error message?
-
Resolution
The is a message noting that using "direct connect" will not support advanced object types as listed. If support for advanced objects are needed:
1. Install a full Oracle client and connect using TNS/LDAP, not direct connect.
or
2. Install at least an instant client and connect using TNS/LDAP, not direct connect.*
*In order to have support for cross connection queries with an instant client setup, make sure to also install an Oracle ODBC driver.
These files would need to be downloaded from Oracle, or discuss the installation with the DBA or System admin.
-
Additional Information
Note: A full Oracle Client or Instant Client files can be downloaded directly from Oracle, or check with your DBA/System admin to get this set up. http://www.oracle.com/technetwork/database/enterprise-edition/overview/index.html There are two tabs in the TDP connection window for Oracle. Once is noted as Direct, this connects as TCP/IP and does not need a client but has limited functionality. The other tab is the option to connect using the "Oracle Client" as TNS or LDAP. In this case you need to have an Oracle Client and TNS/LDAP installed and set up locally. If a client is not installed (or not a supported version) this tab will be grayed out.