dblink_ora_connect() v16
The dblink_ora_connect()
function establishes a connection to an Oracle database with user-specified connection information. The function comes in two forms.
The signature of the first form is:
Where:
conn_name
specifies the name of the link.server_name
specifies the name of the host.service_name
specifies the name of the service.user_name
specifies the name used to connect to the server.password
specifies the password associated with the user name.port
specifies the port number.asDBA
isTrue
if you want to requestSYSDBA
privileges on the Oracle server. This parameter is optional. If omitted, the value isFALSE
.
The first form of dblink_ora_connect()
returns a TEXT
value.
The signature of the second form of the dblink_ora_connect()
function is:
Where:
foreign_server_name
specifies the name of a foreign server.asDBA
isTrue
if you want to requestSYSDBA
privileges on the Oracle server. This parameter is optional. If omitted, the value isFALSE
.
The second form of the dblink_ora_connect()
function allows you to use the connection properties of a predefined foreign server when connecting to the server.
Before invoking the second form of the dblink_ora_connect()
function, use the CREATE SERVER
command to store the connection properties for the link to a system table. When you call the dblink_ora_connect()
function, substitute the server name specified in the CREATE SERVER
command for the name of the link.
The second form of dblink_ora_connect()
returns a TEXT
value.