dblink_ora_connect() v18

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:

dblink_ora_connect(<conn_name>, <server_name>, <service_name>, <user_name>,
<password>, <port>, <asDBA>)

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 is True if you want to request SYSDBA privileges on the Oracle server. This parameter is optional. If omitted, the value is FALSE.

The first form of dblink_ora_connect() returns a TEXT value.

The signature of the second form of the dblink_ora_connect() function is:

dblink_ora_connect(<foreign_server_name>, <asDBA>)

Where:

• foreign_server_name specifies the name of a foreign server.

• asDBA is True if you want to request SYSDBA privileges on the Oracle server. This parameter is optional. If omitted, the value is FALSE.

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.