Query Parameters with SQL*NET connection

mitsosv · Post by **mitsosv** » Thu 05 Jan 2006 14:01

I have a problem using parameters with TSQLQuery and dbexpoda.dll when I connect to Oracle via SQL*Net.
When I execute the query and the parameter is last (or first) then everything is ok. But when I'm positioning the parameter as second then I'm getting Oracle Error 1036.

I use Delphi 7, Oracle
I'm using for debugging purposes a table TEST1 with 3 columns:
C varchar(20), N NUMERIC, D Date.

When I'm using "INSERT INTO TEST1 (C,D,N) VALUES ('C2',19.3,:D)", I supply the parameter and everything is OK.
When I'm using "INSERT INTO TEST1 (C,D,N) VALUES ('C2',:D,19.3)", I supply the parameter and I'm getting ORA-1036 error message.

When I work with OCI then everything is OK.

Paul · Post by **Paul** » Tue 17 Jan 2006 07:50

We reproduced your problem and fixed it. This fix will be included in the
next DbxOda build.
Please add space between ":D," and "19.3" as a workaround
INSERT INTO TEST1 (C,D,N) VALUES ('C2',:D, 19.3)