Eclipse Community Forums: DTP » unable to build Stored procedures

Help

Home

Home » Eclipse Projects » DTP » unable to build Stored procedures

Show: Today's Messages :: Show Polls :: Message Navigator

unable to build Stored procedures [message #596587]

Thu, 08 October 2009 14:45

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 ...;;

Report message to a moderator

Re: unable to build Stored procedures [message #596935 is a reply to message #596587]

Fri, 11 December 2009 19:00

Brian Payton
Messages: 144
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 ...;;

Report message to a moderator

Previous Topic:	unable to build Stored procedures
Next Topic:	Need help generating the SQL Parser

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 07:50:58 EDT 2013