Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » unable to build Stored procedures
unable to build Stored procedures [message #596587] Thu, 08 October 2009 14:45 Go to next message
No real name is currently offline No real name
Messages: 2
Registered: October 2009
Junior Member
Hi all
I recently upgraded to galileo and it does not support org.eclipse.wst.rdb.sqleditor.SQLEditor which I was using to edit and build my stored procs. So with DTP how do I instruct it to use a specific statement terminator so that it does not confuse the semicolons within the store proc definition and the statement terminators used to drop and create the stored proc
below is how I used to define my stored procs using org.eclipse.wst.rdb.sqleditor.SQLEditor. (double semicolon vs. single semicolon)

Thanks
T


-- <ScriptOptions statementTerminator=";;" />
DROP PROCEDURE IF EXISTS ... ;;
CREATE PROCEDURE
...;
...;
END;;
GRANT EXECUTE ON PROCEDURE ...;;
Re: unable to build Stored procedures [message #596935 is a reply to message #596587] Fri, 11 December 2009 19:00 Go to previous message
Brian Payton is currently offline Brian Payton
Messages: 152
Registered: July 2009
Senior Member
What type of database are you using? The statement terminator in the
SQLEditor defaults to ";", but this can be overridden by enablement
plugins. The logic is in the SQLService.splitSQL class.

You might want to try the Data Studio product, which is built on top of
DTP. The SQL editor it includes supports the <ScriptOptions
statementTerminator=...> annotation in your script.
There is a free version available at
http://www-01.ibm.com/software/data/optim/data-studio/featur es.html

taly81010@yahoo.com wrote:
> Hi all
> I recently upgraded to galileo and it does not support
> org.eclipse.wst.rdb.sqleditor.SQLEditor which I was using to edit and
> build my stored procs. So with DTP how do I instruct it to use a
> specific statement terminator so that it does not confuse the semicolons
> within the store proc definition and the statement terminators used to
> drop and create the stored proc
> below is how I used to define my stored procs using
> org.eclipse.wst.rdb.sqleditor.SQLEditor. (double semicolon vs. single
> semicolon)
>
> Thanks
> T
>
>
> -- <ScriptOptions statementTerminator=";;" />
> DROP PROCEDURE IF EXISTS ... ;;
> CREATE PROCEDURE ..;
> ..;
> END;;
> GRANT EXECUTE ON PROCEDURE ...;;
Previous Topic:unable to build Stored procedures
Next Topic:Need help generating the SQL Parser
Goto Forum:
  


Current Time: Thu Apr 17 00:06:10 EDT 2014

Powered by FUDForum. Page generated in 0.04170 seconds