On 03/12/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
Get rid of the trailing semi-colon which is only meant for the sql
client. See also
http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/58a27505-a3fb-4cb1-9063-3946b3f26acd.
Ludo
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
