OCIGetTnsnamesPath

Home

4D v16

OCIGetTnsnamesPath


OCIGetTnsnamesPath -> Function result

Parameter	Type	Description
Function result	String	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.