OCIGetTnsnamesPath

4D v16

OCIGetTnsnamesPath


OCIGetTnsnamesPath -> Resultado

Parâmetro	Tipo	Descrição
Resultado	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.