Master/Detail issues

kurtbilde · Post by **kurtbilde** » Sat 15 Sep 2007 18:21

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

kurtbilde · Post by **kurtbilde** » Sat 15 Sep 2007 18:25

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

kurtbilde · Post by **kurtbilde** » Sun 16 Sep 2007 17:09

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

-Kurt

Plash · Post by **Plash** » Mon 17 Sep 2007 09:15

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.