ODAC 6.0.0.6: Issue with refresh sql.
Posted: Tue 24 Apr 2007 14:44
Hi Folks!
In editing the SCOTT.EMP table with the QuoteNames option turned on, it generates the following refresh SQL which fails with ORA-01741: illegal zero-length identifier (note the doubled double quotes on empno.)
select * from emp
WHERE
"EMP".""EMPNO"" = :"EMPNO"
Thanks for any help!
-Mark
In editing the SCOTT.EMP table with the QuoteNames option turned on, it generates the following refresh SQL which fails with ORA-01741: illegal zero-length identifier (note the doubled double quotes on empno.)
select * from emp
WHERE
"EMP".""EMPNO"" = :"EMPNO"
Thanks for any help!
-Mark