Re: Anyone have trouble issuing a DELIMITER command via JDBC driver?
Posted by: Bill Karwin
Date: December 12, 2006 05:37PM

DELIMITER is a command that is pre-parsed by a client that runs SQL scripts, e.g. mysql command-line tool or MySQL Query Browser.

It should be unnecessary to use DELIMITER if you're executing one statement at a time through JDBC or another programming interface. DELIMITER is necessary only when the semicolon inside a trigger or procedure body is ambiguous with the semicolon at the end of the the CREATE or ALTER statement. If you're using an API that executes only one statement at a time, there's no ambiguity.

Regards,
Bill K.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.