On Tue, Apr 22, 2014 at 01:58:56PM +0200, Franck Routier wrote: [snip] > That said, I was hit by another (related) problem this week-end, with > Oracle. > The validation query was configured as 'select 1 from dual;'. Notice the > semi-column: this broke everything with intermittent ORA-12516 errors. > Removing the semi-column fixes my app with Oracle. > Has anyone an idea of what is happening with this ; ?
I believe that the semicolon is a delimiter used by SQL*Plus (and many other interactive tools for DBMS access). It seems to be used by SQL itself only in the module language and embedded SQL, where a statement delimiter is needed. It's not part of an SQL statement, so it probably doesn't belong in a query string. Commandline tools need a statement delimiter, but statements fed to the DBMS programmatically are delimited by end-of-string. -- Mark H. Wood, Lead System Programmer mw...@iupui.edu Machines should not be friendly. Machines should be obedient.
signature.asc
Description: Digital signature
