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

[Ludo Brands]

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