ODAC 5.80 adds spaces to the end of SQL

[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.

[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 := ' ';