Re: Dynamically creating procedures

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Giedt, Matt wrote:
> Thanks Paul. 
> 
> Good tip on executing the drop command outside of the 'delimiter +
> create'. You have to do this w/ SQL Server as well -- I should have
> caught that. (As opposed to Oracle which lets you do 'create or
> replace')

Hi Paul,

> I can't, however, get past the DELIMITER statement.
> 
>       stmt.execute( "DELIMITER |" ); // <-- blows up here

That's because "DELIMITER" isn't a SQL statement, it's for the mysql
command-line client. There's no need for the construct in client
libraries, as the string you pass to Statement.execute() has a length
(and thus doesn't have to be parsed for a token to find the "end").

Drop your "delimiter" statements, and you should be good to go.

	-Mark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHrQB1tvXNTca6JD8RArsJAJsEUc6rrTE0ZT2RqH04So1qEYJB/wCfVwvx
TF7ngjrr76qaw63vlg/aWDQ=
=YEHl
-----END PGP SIGNATURE-----

-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]