OraFAQ Forum: Windows » Windows batch job Help

Home » Infrastructure » Windows » Windows batch job Help (windows Xp,oracle 9i)

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

Windows batch job Help [message #359846]

Tue, 18 November 2008 06:02

Srinandini
Messages: 13
Registered: November 2008

Junior Member

Hi All

My requirement isto call .sql script files from a windows batch (.bat) file. The filename is given as input

The SQl scripts will have stateements to create table, alter structute etc

I have developed a sample batch job that takes a Stored procedure's name as nput and executes it

But am not able to call sql files within the .bat file

Could you please help on this?

Regards
Srinandini

Report message to a moderator

Re: Windows batch job Help [message #359852 is a reply to message #359846]

Tue, 18 November 2008 06:06

joicejohn
Messages: 327
Registered: March 2008
Location: India

Senior Member

Srinandini,

Can you please post the script of the batch files?

Regards,
Jo

Report message to a moderator

Re: Windows batch job Help [message #359853 is a reply to message #359846]

Tue, 18 November 2008 06:07

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

Senior Member
Account Moderator

Can you search in the Windows forum?

Regards
Michel

Report message to a moderator

Re: Windows batch job Help [message #359866 is a reply to message #359846]

Tue, 18 November 2008 06:31

Srinandini
Messages: 13
Registered: November 2008

Junior Member

@echo off
set PNAME=%1
echo Command Line Argument: %PNAME%

echo connect produser/password@cms_prd_bg01 >%0.tmp
echo set serveroutput on;>>%0.tmp
echo exec %PNAME%; >>%0.tmp

rem -- Run sql script --
sqlplus /nolog @%0.tmp

rem -- Cleanup --
del %0.tmp

goto End

:Usage
echo Usage: %0 TABLE_NAME

:End

this is the bat code. Am passing a name of the SP as input where it works fine

But i need to pass filename as input . Amexecuting the batch file from cmd prompt

I tried to place all the stmts in the SQl scripts inside the Sp.
But since i used execute immediate am facing the problem of Insufficient previleges

So can u pls help me how to go abt this?

Report message to a moderator

Re: Windows batch job Help [message #359871 is a reply to message #359866]

Tue, 18 November 2008 06:53

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Dont know if I understand you correctly, but if you want to "send" the filename as an input parameter to your bat file.

Code: [Select all] [Show/ hide]

set procname=%1
set filename=%2

echo connect produser/password@cms_prd_bg01 >%filename%

then just

Code: [Select all] [Show/ hide]

C:\>test.bat P1 C:\>myscripts\myfile.tmp

[Updated on: Tue, 18 November 2008 06:54]

Report message to a moderator

Re: Windows batch job Help [message #359874 is a reply to message #359871]

Tue, 18 November 2008 07:07

Srinandini
Messages: 13
Registered: November 2008

Junior Member

Besides passing the filename as input i have to execute the file
It's a SQL file that consists of DDL/DML scripts

Report message to a moderator

Re: Windows batch job Help [message #359875 is a reply to message #359874]

Tue, 18 November 2008 07:09

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

No problem

just

Code: [Select all] [Show/ hide]

cmd /k sqlplus "%CONNECT_USER%@%TNS%" @%filename%

[Updated on: Tue, 18 November 2008 07:10]

Report message to a moderator

Previous Topic:	InitialLOBFetchSize & FetchSize."oracle"
Next Topic:	Oracle 10g installation with 4GB RAM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 14:01:03 CDT 2025