ORA-1036 in direct mode

[a-s-z]

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

[sinys]

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

[AlexP]

Hello,

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