OraScript cannot parse PL/SQL block preceeded by a comment

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
holger_nis
Posts: 7
Joined: Wed 26 Nov 2014 10:02

OraScript cannot parse PL/SQL block preceeded by a comment

Post by holger_nis » Thu 30 Apr 2020 11:03

The latest ODAC build introduced a problem with the TOraScript component.
if your script contains an anonymous PL/SQL block that is preceeded by a comment, the OraScript component takes the first two lines as a separate statement, i.e. the line starting with "begin" is handled as the beginning of the next statement.
You can reproduce it using the following example:

Code: Select all

-- this is a comment
declare
  i integer;
begin
  null;
end;
Regards,
Holger

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: OraScript cannot parse PL/SQL block preceeded by a comment

Post by MaximG » Mon 18 May 2020 16:38

Thank you for the information. We've reproduced the issue and fixed it. The fix will be included in the next build of our product.

Post Reply