Page 1 of 1

ODAC 10.03.08 and GRANT problem

Posted: Tue 18 Dec 2018 20:17
by 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;

Re: ODAC 10.03.08 and GRANT problem

Posted: Sat 22 Dec 2018 12:57
by 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.