Execute oracle script from batch file

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 3. Ranyalak Sopa dice:. Nombre obligatorio. In Archive. Blog de WordPress. Seguir Siguiendo. Its contents is as follows.. When I run the above batch file manually it runs without any error and it creates the statspack report..

But when I execute this code, the batch file gets opened in command prompt and closes immediately without showing any informations.. Yeah I use the relative path to refer to the sql script and it runs perfect when i ren the batc file and I also set the working directory too.. Office Office Exchange Server.

Not an IT pro? Resources for IT Professionals. Sign in. United States English. In the following example, we check the database is up before starting a Tomcat application server. If the database is down, the script sleeps for 5 minutes, then checks again. The script requires an Oracle Client to make connections to the database.