OraFAQ Forum: Windows » Script File execution

Home » Infrastructure » Windows » Script File execution (Oracle, 10g, Windows)

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

Script File execution [message #350901]

Sat, 27 September 2008 02:00

Diamond.Jegan
Messages: 3
Registered: September 2008
Location: India

Junior Member

I want to run a sql script file apart from Oracle. For example,
I'm running that script file from VB-Ado by the following code snipet

AdoConnectionObject.Execute "@" & scriptFileName

Above mentioned statement gives error while running as 'Invalid SQL Statements'.

Please help me for this problem.

By,
Diamond

Report message to a moderator

Re: Script File execution [message #350903 is a reply to message #350901]

Sat, 27 September 2008 04:10

msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT

Member

Hi,

I think you cannot call sqlscriptfile (as .Execute @sqlfilenm), but from sqlprompt it is (@sqlfilenm). From VB it is like this :

strsql="select a,b,c from xyz"
adodbconn.execute(strsql)

Thanx and Regards,

MSMallya

Report message to a moderator

Re: Script File execution [message #350921 is a reply to message #350901]

Sat, 27 September 2008 12:00

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

Senior Member
Account Moderator

@ (or start or @@) is a SQL*Plus command not a SQL one.
You cannot execute a script in VB, you have to read and execute each statement of the script.

Regards
Michel

Report message to a moderator

Re: Script File execution [message #351009 is a reply to message #350903]

Sun, 28 September 2008 23:33

Diamond.Jegan
Messages: 3
Registered: September 2008
Location: India

Junior Member

I have a Create View script in that script file. I want to execute implicitly i.e. without using SQLPlus Window. Fox example using DOS batch file. Is this possible?

Report message to a moderator

Re: Script File execution [message #351032 is a reply to message #351009]

Mon, 29 September 2008 01:16

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

Senior Member
Account Moderator

I don't understand the question nor the relation with the previous one.
VB/ADO can execute a "create view" statement.

Regards
Michel

Report message to a moderator

Re: Script File execution [message #351844 is a reply to message #351032]

Fri, 03 October 2008 07:46

Diamond.Jegan
Messages: 3
Registered: September 2008
Location: India

Junior Member

I have the following SQL code

Create View vu_TestView
as
--EMP MASTER
Select EmpCode,EmpName,SAL from TBLEMPMASTER

UNION

--EMPLOYEE TRANS
SELECT EMPCODE,'',SALARY FROM TBLEMPLOY_TRANS;

Consider this is a simple view. I've saved this file as TestScript.sql. What i want is I want to execute this script file externally. I've one suggesstion that is

"sqlplus user/password@schema @c:\TestScript.sql"

The above should be done in DOS mode by using cmd. But I got error at the time of execution. So I need to execute the script file execution such that way (DOS) without accessing Oracle IDE.

Report message to a moderator

Re: Script File execution [message #351858 is a reply to message #351844]

Fri, 03 October 2008 08:38

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

Senior Member
Account Moderator

So read the file and execute the statements that are in.
Just like SQL*Plus does it.

Regards
Michel

Report message to a moderator

Re: Script File execution [message #352918 is a reply to message #351858]

Fri, 10 October 2008 04:29

Vairam_Jegan
Messages: 1
Registered: July 2005
Location: Chennai

Junior Member

I tried the script file execution in vb using FSO (File System Object). At that time also I got the same error. So I decided to run that script file apart from vb-ado and oracle. What I’m asking is like batch file (*.bat) execution. Do you have any idea about this script file execution through batch file?

[Updated on: Fri, 10 October 2008 04:59] by Moderator

Report message to a moderator

Re: Script File execution [message #353002 is a reply to message #352918]

Fri, 10 October 2008 08:33

msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT

Member

Hi,

I think you have not put "exit;" in your script. Also you have not posted error you have encountered.

say batch file test.bat will look like

sqlplus user/pwd@db @c:\testsc.sql

and sql script will look like

set termout off;
select col1 from abc;
exit;

I have given you only simple example how to call/execute script file from DOS command prompt.

Thanks and regards,

MSMallya

Report message to a moderator

Previous Topic:	OLE DB drivers for IA64
Next Topic:	How to configure Oracle 10g for XP sample schemas

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 20 19:39:22 CST 2025