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
- :
- Executing PL/SQL in SQLScripts
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 14, 2009
08:18 AM
Executing PL/SQL in SQLScripts
Hello
I tried to execute real PL/SQL scripts in my IS project
But it failed because the syntax must be TransactSQL and not PL/SQL even if I choose a Oracle Connection.
Can someone explain me if there is a way to execute a real PL/SQL script with for example ';' at end of line and without any 'Go' instruction.
Thank you for your answer
FC
I tried to execute real PL/SQL scripts in my IS project
But it failed because the syntax must be TransactSQL and not PL/SQL even if I choose a Oracle Connection.
Can someone explain me if there is a way to execute a real PL/SQL script with for example ';' at end of line and without any 'Go' instruction.
Thank you for your answer
FC
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 14, 2009
09:32 AM
You can specify a different batch separator from GO in the Batch Separator setting on the Connection | Advanced tab.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 14, 2009
10:16 AM
Thank you for this response
When I change from 'Go' to ';' it works but with restrictions :
Both of following version of code are working with sqlplus.exe ... but :
The following version is OK in IS 2009
The following version is NOT OK in IS 2009
It seems for me like a great restrictions because it does not permit to use basic PL/SQL scripts without nothing to do to use them with IS.
Is there a way to bypass this restriction ?
When I change from 'Go' to ';' it works but with restrictions :
Both of following version of code are working with sqlplus.exe ... but :
The following version is OK in IS 2009
create user toto identified by toto default tablespace USERS
;
The following version is NOT OK in IS 2009
create user toto identified by toto default tablespace USERS ;
It seems for me like a great restrictions because it does not permit to use basic PL/SQL scripts without nothing to do to use them with IS.
Is there a way to bypass this restriction ?