Hi Folks,

For one of my requirements I need to connect to the oracle server from within a sql server stored procedure and then proceed to do some operations.
How do I check whether the oracle server is up and running? If it is running then only do the remaining operations.

Actually I am importing some data from oracle to sql server database (Both the servers are on different machines). For that I have created one DTS package. And I am running that DTS package though a stored procedure. Before executing the DTS I truncate the tables , in the sql server database, for which the data is to be imported. But if for some reasons the DTS is not run the tables remain empty. So before truncating the data I wanna check if the oracle connectivity is there.

Let me know.

Thanx in advance.

Regards,

Samir Kudav.