Home
SQL Image Viewer online help Prev Page Prev Page
Introduction
About SQL Image Viewer
Version history
Contact us
User Guide
System requirements
Editor command selection
Exporting large number of images
Reference Guide
Main menu
Connect to Database
Connecting to databases directly without client libraries installed
Connecting to an Oracle database
Connecting to a DB2 database
Options
General options
Thumbnail options
Hex view
The work area
SQL editor
Results
Other binary data
Image viewer
Hex viewer
Export items wizard
Post-processing Office files
Image options
File naming convention
Datetime format specifiers
Command line interface
Parameters, logs and exit codes
Advanced options
CROP option
Troubleshooting
Expired trial
Invalid licenses
Unidentified images or binary data
DICOM images
Hidden Excel worksheets

Connecting to an Oracle database

You can connect to an Oracle database using the Oracle Call Interface (OCI), or directly via TCP/IP. The direct option allows you to connect to an Oracle database without the need to install the OCI components on your computer. However, there are certain limitations when using the direct option:
· 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 (or IP address), 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.
login_oracledirect