Manage OraKeywordLexems

[sinys]

We use OraScript for random users scripts from IDE for Oracle and one of the most common command it's SET DEFINE and SET FEED and other SET commands. Please do event for manage this keywords or even be add SET to ignore as PROMPT and REMARK.

[AlexP]

Hello,

You can cancel execution of the SET command in the TOraSQL.BeforeExecute method as follows:

Code: Select all

procedure TForm1.OraScript1BeforeExecute(Sender: TObject; var SQL: String;
  var Omit: Boolean);
begin
  IF Pos('SET', UpperCase(Trim(SQL))) = 1 then
    Omit := True;
end;

[dados]

What about a block like this:

begin
REM This is a comment
dbms_output.put_line('test');
end;

or a statement like this

select *
REM This is a comment
from dual

Can ODAC ignore these rem comment's?

Regards,
Arni Thor

[bork]

Why should ODAC ignore the REM statement? REM is not a comment directive in Oracle. If you need a comment, you should write SQL like this:

Code: Select all

begin
  /* This is a comment */
  dbms_output.put_line('test');
end;

or

Code: Select all

select *
/* REM This is a comment */
from dual