OraFAQ Forum: SQL & PL/SQL » Batch File to run SQL Program

Home » SQL & PL/SQL » SQL & PL/SQL » Batch File to run SQL Program

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Batch File to run SQL Program [message #20213]

Tue, 07 May 2002 04:03

sql gurus
Messages: 22
Registered: May 2002

Junior Member

Hi,

Can any one tell me how to write a batch file which runs an sql program without asking for username and password.

I tried like this.

SQLPLUS.EXE USER/PWD@DATABASE <file.sql>

It is not working.

Report message to a moderator

Re: Batch File to run SQL Program [message #20217 is a reply to message #20213]

Tue, 07 May 2002 06:48

Grant
Messages: 578
Registered: January 2002

Senior Member

What is the exact error you get when you run this command?

Report message to a moderator

Re: Batch File to run SQL Program [message #20221 is a reply to message #20213]

Tue, 07 May 2002 09:05

sql gurus
Messages: 22
Registered: May 2002

Junior Member

The program is not getting started at all

Report message to a moderator

Re: Batch File to run SQL Program [message #20223 is a reply to message #20213]

Tue, 07 May 2002 22:18

S.Muthu Kumar
Messages: 6
Registered: July 2001

Junior Member

Hi,

create a sql file with the following contents
select * from emp;

save it as c:test.sql

Create a batch file with the following contents

sqlplus scott/tiger@db c:test

execute the batch file.

This shld solve ur reqmt.

HTH
S.Muthu Kumar

Report message to a moderator

Re: Batch File to run SQL Program - correct [message #20224 is a reply to message #20213]

Tue, 07 May 2002 22:19

S.Muthu Kumar
Messages: 6
Registered: July 2001

Junior Member

Hi,

create a sql file with the following contents
select * from emp;

save it as c:test.sql

Create a batch file with the following contents

sqlplus scott/tiger@db @c:test

execute the batch file.

This shld solve ur reqmt.

HTH
S.Muthu Kumar

Report message to a moderator

Thanks [message #20260 is a reply to message #20224]

Thu, 09 May 2002 07:22

sql gurus
Messages: 22
Registered: May 2002

Junior Member

Thanks Kumar. It worked. I just missed @ symbol

Report message to a moderator

Previous Topic:	Foreign Key Reference
Next Topic:	Storing Images in Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 05:46:14 CDT 2024