[fpc-pascal] Oracle driving me crazy - please provide dried frog pills[1]

[Reinier Olislagers]

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



[1] If you're not a Terry Pratchett fan, never mind...