ODAC 10.03.08 and GRANT problem

[heidenbluth]

The new version does not cope correctly with GRANT statements, if the command spreads on more than one line.
Example:

Code: Select all

GRANT SELECT
ON MYTABLE
TO MYROLE

If you comment out the following lines in OraScriptProcessor.pas, it works fine again:

Code: Select all

procedure TCustomOraScriptProcessor.CheckLexem(
...
      ST_UNKNOWN:
          ..
//          lxGRANT, lxREVOKE: // commented out
//            StatementType := ST_PRIVILEGES;

[MaximG]

Thank you for the information. We have reproduced the problem and fixed the bug. The fix will be included in the next ODAC build. We are preparing a release of our product with this changes until the end of this year.