When the server I am trying to connect is down I receive the following error:
ORA-29260: network error: TNS:no listener
ORA-06512: at "SYS.UTL_TCP", line 410
ORA-06512: at "SYS.UTL_TCP", line 252
ORA-06512: at "SAR.INTSAR", line 50
I am using SQL Navigator for Oracle 4.2.
How can I use this in a PL Package so that I can test if this error occurs right at the start of the package so I can take a different action then running the rest of the script?
Example:
If this error is found... run a different package and then end the one I am in.
Thanx in advance!
Michel, São Paulo, Brazil
ORA-29260: network error: TNS:no listener
ORA-06512: at "SYS.UTL_TCP", line 410
ORA-06512: at "SYS.UTL_TCP", line 252
ORA-06512: at "SAR.INTSAR", line 50
I am using SQL Navigator for Oracle 4.2.
How can I use this in a PL Package so that I can test if this error occurs right at the start of the package so I can take a different action then running the rest of the script?
Example:
If this error is found... run a different package and then end the one I am in.
Thanx in advance!
Michel, São Paulo, Brazil
