| Remote DB Connection error [message #67311] |
Wed, 21 April 2004 10:57 |
Manish
Messages: 79
Registered: December 2000
|
Member |
|
|
Hi All,
I would like to catch connection error to remote database.
For example my current database is oracle1 and I want to access anothe database oracle2 (this is a link which is created in oracle1). If oracle2 is down I want my query in oracle1 to report exception/error.
The code which I'm writing in oracle1 is:
begin
select count(*) from employee@oracle2;
end;
Thanks,
Manish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
