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

[Tomas Hajny]

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