Problem executing SQL srcripts on Oracle 10g database

[pradana]

Hi all,

I'm adding SQL scripts to my InstallShield project (Web Project). At the SQLLogin dialog, after I click the "Next" button, an error message appears saying I have an invalid character at line 25

Here's the SQL Script:

--------------------------------------------------------------------------------------------------
--                                                                            
--  File Name:   sqlscript.sql                                   
--                                                                            
--  Description: Blank SQL script                                          
--                                                                            
--  Comments:    This blank script is intended for advanced users. 
--               To create a script from an existing database with step-by-step  
--		         instructions, use the Database Import Wizard. 
--                                                                                                               
---------------------------------------------------------------------------------------------------

--------------------------------------------------------
--  File created - Saturday-August-23-2008   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table OBJECTATTACHMENT
--------------------------------------------------------

CREATE TABLE "OBJECTATTACHMENT" ("OBJECTID" RAW(16), "ATTACHMENTID" RAW(16));
--------------------------------------------------------
--  DDL for Table OBJECTPARENTLINK
--------------------------------------------------------

CREATE TABLE "OBJECTPARENTLINK" ("OBJECTID" RAW(16), "PARENTOBJECTID" RAW(16));

Is it about the ";" sign? When I remove the last ";" sign, the same error appears. When I remove both signs, the error message "invalid or missing option" appears. :confused:

The only thing that works is when I execute ONLY one line of SQL statement without ";", while in fact I have thousands lines of SQL statements to execute. :eek:

Any idea? Thanks in advance.

[hidenori]

Do you specify ; as the batch separator for your connection? The default batch separator is GO. You can change the setting in the Advanced tab.

[pradana]

OK it works now, I set the batch separator to "/". Thanks 😉