OCIGetTnsnamesPath

4D v16

OCIGetTnsnamesPath


OCIGetTnsnamesPath -> Résultat

Paramètre	Type	Description
Résultat	Chaîne	Pathname of Oracle home folder

The OCIGetTnsnamesPath command returns the full path of the Oracle home folder.

This function is especially useful if you need to access certain files from the Oracle home folder.

Get the list of entry points contained in the "tnsnames.ora" file.

 $TnsPath:=OCIGetTnsnamesPath

 oci_tool_GetEntryName($TnsPath+"Network"\Admin\tnsnames";->oci_tTnsNameEntry)

oci_tool_GetEntryName is a 4D method that allows analyzing the "tnsnames.ora" file to extract entry points and save them in a text array.