Multiple lines sql script

[Mayank23]

Hi I am using Installshield 2009 and my problem is whenever I try to execute Multiple lines sql script it throws an error but it works fine when I use a single line script without a semi-colon.How to solve this problem?Can anyone please guide me ?

I am connecting to Oracle 10g ,
and Everything is fine as long as it is a single line script.:eek:

[hidenori]

You may need to use the batch separator as follows:

script line 1
GO

script line 2
GO

[Mayank23]

:cool: thanks it worked !!
Only thing is i have to move all the "GO"s in the next line.. 😄