| · | Direct
connection is only possible using the TCP/IP network protocol .
|
| · | The
following data types are not available: OBJECT, ARRAY, REF, XML,
BINARY_DOUBLE, BINARY_FLOAT. |
When connecting via OCI, you need to enter the TNS name of the database, together with the user name and password.
When connecting directly via TCP/IP, you need to enter the host name, port number and database SID separated by colons e.g.
| ORAPROD01:1521:FINANCE
|
where ORAPROD01 is the host name, 1521 is the port number that the Oracle service is listening on, and FINANCE is the database SID.
