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: Oracle SQL Script Error
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
‎Apr 19, 2010
11:37 PM
Oracle SQL Script Error
This is the same issue as:
http://community.flexerasoftware.com/showthread.php?t=178929
When running a Oracle script (with semi-colons) i get a ORA-00911 error
What has happened in this case is that ORA-00911 is thrown because of a semi-colon in the SQL of UDM. The semi-colon is an invalid character, causing ORA-00911 to appear. To fix, you should try the SQL again without the inappropriate semi-colon to remedy the ORA-00911 error.
http://www.dba-oracle.com/sf_ora_00911_invalid_character.htm
When this script is run manually - I dont get this error;
I am using a batch char .. and its /
Why does InstallShield give me this error? is there a workaround?:confused:
Thanks
-Aaron
http://community.flexerasoftware.com/showthread.php?t=178929
When running a Oracle script (with semi-colons) i get a ORA-00911 error
What has happened in this case is that ORA-00911 is thrown because of a semi-colon in the SQL of UDM. The semi-colon is an invalid character, causing ORA-00911 to appear. To fix, you should try the SQL again without the inappropriate semi-colon to remedy the ORA-00911 error.
http://www.dba-oracle.com/sf_ora_00911_invalid_character.htm
When this script is run manually - I dont get this error;
I am using a batch char .. and its /
Why does InstallShield give me this error? is there a workaround?:confused:
Thanks
-Aaron
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 20, 2010
06:14 AM
Guess you are adding scripts from SQL scripts section. Check the connection properties and other properties set for the connection.
Possibly this does have a Go as end of file and you have / in your file.
Possibly this does have a Go as end of file and you have / in your file.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 20, 2010
04:57 PM
Thanks you guys!