Hi All,
Can anybody tell me the standard way to read the tnsnames.ora file and connect to database automatically.
I have the name of the service(i.e
TEST from below entry in tns file) , Username and Password.
a samle entry in tnsnames.ora:-
So now I have only the name TEST and I have to connect this DB after reading its host IP(10.5.3.1) and port address(1521).
Please help with code.
Thanks,
Kousik