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)

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