cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Mayank23
Level 4

Multiple lines sql script

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:
Labels (1)
0 Kudos
(2) Replies
hidenori
Level 17

You may need to use the batch separator as follows:

script line 1
GO

script line 2
GO
0 Kudos
Mayank23
Level 4

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