This content has been marked as final. Show 3 replies
The ORCL= is only used by the TNS libraries to parse out the alias into the name-value pair. You can almost always directly substitute the name-value pair for the alias as a connect string.
Thanks Mark. I was doing it other way round by trying to build the string which didn't work but just substitute works great.
Could you give an example how the connection worked without TNS Name? I was trying but failed to make it work.