On Mon, December 3, 2012 16:44, Reinier Olislagers wrote: > Been fiddling with the Oracle connector. > > This: > using the scott schema on Oracle 10g, this works fine in my JDBC query > GUI and in sql*plus: > select * from scott.emp where JOB='CLERK'; > > However, in code (FPC trunk x86, Windows), this: > Q.SQL.Text:='select * from EMP WHERE JOB=''CLERK'';'; > gives ORA-00911: invalid character!?!? > (with the 11g instant client) > > What am I doing wrong? > > Program can be downloaded here: > https://bitbucket.org/reiniero/fpc_laz_patch_playground/downloads/dberror.lpr
I don't know what you're doing wrong, but I'd try excluding the semicolon. Tomas _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
