Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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
ConnectionString1
Else
ConnectionString2
End if
Now how do I check if first/second connection is successful or not in script?
Any help would be great.
Thanks in advance.
Cheers,
Amay.
Hi Amay,
you can catch the ScriptError:
set ErrorMode=0;
CONNECT <ConnectionString1>...;
if ScriptError>1 then
//not connected ConnectionString1...
CONNECT <ConnectionString2>...;
end if
set ErrorMode=1;
- Ralf
Hi Amay,
you can catch the ScriptError:
set ErrorMode=0;
CONNECT <ConnectionString1>...;
if ScriptError>1 then
//not connected ConnectionString1...
CONNECT <ConnectionString2>...;
end if
set ErrorMode=1;
- Ralf
Thanks Ralf