Home » Infrastructure » Other Operating Systems » Returning exit code from PLSQL Batch file to VMS
Returning exit code from PLSQL Batch file to VMS [message #151001] Mon, 12 December 2005 09:48
sunil_403
Messages: 1
Registered: December 2005
Junior Member
Hi all,

I have been stuck in a small problem for quite smetime now.

In the .com (script) file in the Open VMS environment that I am writing a .sql file is called which does some archiving of the database. In doing so it first disables all the triggers of some tables. Now, these statements sometimes fail. There is Exception handling in place to handle these exceptions. But I do not know how to return the exit code to the wrapper script. What i essentially want to do is to return an exit code '0' when there is no error and a non zero exit code when there has been some error so that the returned exit code can be picked up by $Symbol variable of VMS. Can any of you please help..

Its kindaa URGENT!! Plz help ASAP...
Previous Topic: Troubles for installing an Oracle Instance on OpenVMS
Next Topic: Flat file
Goto Forum:
  


Current Time: Thu Mar 28 14:58:24 CDT 2024