oracle:USoftConnectString

Returns a valid full database connection string for the Oracle RDBMS on the basis of host name and SID.

Syntax

oracle:USoftConnectString( host, sid )

•If you do not specify host (as in Example 2), the computername of the current computer is used.

•If you do not specify sid (as in Example 2), the string XE is used.

Example 1

<pc:evaluate select="oracle:USoftConnectString('MYSERVER', 'MYSID')"/>

The result is:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MYSERVER)(PORT=1521))(CONNECT_DATA=(SID=MYSID)))

Example 2

<pc:evaluate select="oracle:USoftConnectString('', '')"/>

The result looks like this:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PC4400945)(PORT=1521))(CONNECT_DATA=(SID=XE)))