Page 1 of 1

BUG: ODAC and QueryRecordCount fails if lastline is a commentline

Posted: Wed 21 May 2008 10:35
by gobas1
Hello,

oraQuery.SQL.text := 'select 'X' from dual';
oraQuery.SQL.Add('-- Comment in last line');

oraQuery.Options.QueryRecCount := true;

oraQuery.open; --> 'ORA:00907 : Missing right parenthesis'

This seems to be cause ODAC always adds the closing parenthesis
to the sqlstatement even if it is a commentline.

with regards

L.Bodes

Posted: Wed 21 May 2008 12:59
by Plash
We have fixed this problem. The fix will be included in the next build of ODAC.

Posted: Wed 21 May 2008 14:55
by jfudickar
Did you have a timeframe for this release?

Greetings
Jens

Posted: Wed 21 May 2008 15:01
by Plash
The next build will be released in few days.