Page 1 of 1

ODAC 5.80 adds spaces to the end of SQL

Posted: Tue 06 Jan 2009 01:17
by rmovchan
We found that ODAC appends a space to SQL statement before sending it to Oracle. This causes some problems. For example, DBMS_METADATA sometimes will generate invalid scripts when there's a space after the last END. My question is, is it necessary to append a space and if yes, why? There's no comment in the source code.

Posted: Fri 09 Jan 2009 10:23
by Plash
We have considered to remove this space. The fix will be included in the next ODAC build. You can also remove it in your sources. Add the following code instead:

Code: Select all

  if SQLText = '' then
    SQLText := ' ';