OraFAQ Forum: Windows » Create a Batch File[merged topic]

Home » Infrastructure » Windows » Create a Batch File[merged topic]

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

Create a Batch File[merged topic] [message #288383]

Mon, 17 December 2007 05:27

pritesh
Messages: 5
Registered: December 2007

Junior Member

Does anyone have ideas how to call stored
procedures from batch file? I want to crate a batch file in dos to call Stored Procedure written in oracle.

Report message to a moderator

Re: Create a Batch File [message #288386 is a reply to message #288383]

Mon, 17 December 2007 05:33

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

sqlplus @batchscript.sql

with batchscript.sql:
connect scott/tiger
exec myproc
exit

This is just an example of how to do it.

Regards
Michel

Report message to a moderator

Re: Create a Batch File [message #288389 is a reply to message #288386]

Mon, 17 December 2007 05:49

pritesh
Messages: 5
Registered: December 2007

Junior Member

Hi Michel, Thank you very much.
But I have differ database.
how can I give datbase name?
Details:
DataBase Name: ora-pip
username : Xyz
Password : Abc

Report message to a moderator

Re: Create a Batch File [message #288394 is a reply to message #288389]

Mon, 17 December 2007 05:58

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

sqlplus scott/tiger@mydb @myscript
and no connect inside myscript.sql
or
sqlplus @myscript scott tiger mydb
with
connect &1/&2@&3
inside myscript.sql

Regards
Michel

[Updated on: Mon, 17 December 2007 05:59]

Report message to a moderator

Re: Create a Batch File [message #288398 is a reply to message #288394]

Mon, 17 December 2007 06:39

pritesh
Messages: 5
Registered: December 2007

Junior Member

Hey ,
I am giving you troble once again.
Needed: I want to call Stored Procedure using batch file.
I have crrated sample.sql in c:/sample.sql
Then In SP.BAT file, what should I write?
I have tried followed code.
code:
START C:\oracle\ora92\bin\sqlplusw.exe u100@New/u100
exec pr2(500,'pritesh', 50000)
EXIT
Note: pr2 is my SP. first input is number then varchar2 and number.
Thx.

Report message to a moderator

Re: Create a Batch File [message #288404 is a reply to message #288383]

Mon, 17 December 2007 07:05

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why don't you try what I posted and prefer to start a new topic with something that obviously is from Unix?

Regards
Michel

Report message to a moderator

Re: Create a Batch File [message #288406 is a reply to message #288404]

Mon, 17 December 2007 07:43

pritesh
Messages: 5
Registered: December 2007

Junior Member

Hey Michel,
Can u re-look my problem?
Because, I am not Oracle programmer.
I am working in java.I don't have much info.
I am using window as OS.

Sorry for troubling more.
Thank a lot.
regards,
Pritesh Shah

Report message to a moderator

Re: Create a Batch File [message #288407 is a reply to message #288406]

Mon, 17 December 2007 07:46

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I gave you 2 solutions, they work, if they do not fit what you want to do tell why.

Regards
Michel

[Updated on: Mon, 17 December 2007 07:47]

Report message to a moderator

Re: Create a Batch File [message #288480 is a reply to message #288398]

Mon, 17 December 2007 13:28

Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA

Senior Member

pritesh wrote on Mon, 17 December 2007 04:39

-- Create your c:/sample.sql with the following contents:
exec pr2 (500, 'pritesh', 50000)

-- Then create your sp.bat file with the following contents:
C:\oracle\ora92\bin\sqlplus.exe u100/u100@new @c:\sample.sql

-- Then at your windows command prompt type:
sp.bat

Report message to a moderator

Re: Create a Batch File [message #288513 is a reply to message #288480]

Mon, 17 December 2007 21:30

pritesh
Messages: 5
Registered: December 2007

Junior Member

Hey Brother, Michle
Thanks you so much. It is working nicely.
Good Work Michle!!!

Pritesh

Report message to a moderator

Previous Topic:	ORA-04030 error in Windows 2003!
Next Topic:	Oracle9.2.0.1 Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 19:00:33 CST 2024