Forum Stats

  • 3,734,283 Users
  • 2,246,938 Discussions
  • 7,857,218 Comments

Discussions

Trying to run Oracle query using a batch file.

User_HJS01
User_HJS01 Member Posts: 11 Green Ribbon

Hi All,

Please Note : I am executing ORACLE queries. 

My apologies if this is a repeated question. 

I am a beginner and trying to execute a simple select * query using batch file. 

Here is my syntax: 

sqlplus -s username/[email protected] @C:\Users\xxx\Desktop\OTHER\script1.sql

PAUSE

It throws the error -


However, I have modified the Oracle_Home variable but still getting the same error. Below is how I checked if Oracle_Home is set or not.


Unfortunately, this script does not do anything. Any help will be appreciated.

Answers

Sign In or Register to comment.