This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Problem executing SQL srcripts on Oracle 10g database
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 04, 2008
02:05 AM
Problem executing SQL srcripts on Oracle 10g database
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:
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.
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.
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 04, 2008
09:31 AM
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.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 05, 2008
01:01 AM
OK it works now, I set the batch separator to "/". Thanks 😉