Devart Forums

Posted: **Fri 27 Sep 2013 11:15**

Hi,

we are getting ora-1036 in direct mode when trying to update a table that has column names containing e.g. '$'. DMLRefresh of Query is True. In OCI mode everything works without problems.

Expamle update statement generated by Odac:

Code: Select all

  update foo
  set bar = :bar
  where foo_id = :Old_foo_id
  returning
    foo_id, bar, ctx$uds
  into
    :foo_id, :bar, :ctx$uds

Best regards,
Andre

Posted: **Fri 27 Sep 2013 16:39**

I have the same error ORA-01036: illegal variable name/number in OCI mode in OraSQL and it is not associated with the symbol "$".

Posted: **Mon 30 Sep 2013 14:09**

Hello,

Thank you for the information. We have reproduced and fixed the problem. This fix will be included to the next version.

Devart Forums

ORA-1036 in direct mode

ORA-1036 in direct mode

Re: ORA-1036 in direct mode

Re: ORA-1036 in direct mode