I have to two database connection strings which are from two different oracle database servers but contains same tables and views.
I need to connect to main database server, if connection is successful then i will use this connection string else, I will connect to secondary database server and use secondary connection string to pull the data.
I think script would be like this,
if ConnectionString1='Success' then
Now how do I check if first/second connection is successful or not in script?