BUG: ODAC and QueryRecordCount fails if lastline is a commentline

gobas1 · Post by **gobas1** » Wed 21 May 2008 10:35

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

Plash · Post by **Plash** » Wed 21 May 2008 12:59

We have fixed this problem. The fix will be included in the next build of ODAC.

jfudickar · Post by **jfudickar** » Wed 21 May 2008 14:55

Did you have a timeframe for this release?

Greetings
Jens

Plash · Post by **Plash** » Wed 21 May 2008 15:01

The next build will be released in few days.