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

[Reinier Olislagers]

On 3-12-2012 17:17, Tomas Hajny wrote:
> 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.
> 
Thanks, Tomas, did that already - no effect.