Devart Forums

Hi!

Just doing a normal master/detail, but keep on having ORA-00900 error when trying to fire an update-script. Having issue with a Field called ID, a VarChar2(20) field - suspecing it to be the matter.

Delphi 2007, ODAC 6.1.10.

-Kurt

BTW: My statement is working in Oracle SQL Developer. My OraSQL1 sql is looking like this:

UPDATE PURE.TAB1999_2003_SVAR SET
A = :STATUS
WHERE "Id" = :Nummer

With code looking like this:

OraSQL1.Params[0].Value := CurrentStatus;
OraSQL1.Params[1].Value := ID;
OraSQL1.Execute;

-Kurt

When using Number(6,0) insted of VarChar2 the issue disapears...

-Kurt

We could not reproduce the problem. Please send to odac*crlab*com a complete small sample that demonstrates the problem, including script to create server objects.