Page 1 of 1
Manage OraKeywordLexems
Posted: Mon 12 Aug 2013 15:45
by 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.
Re: Manage OraKeywordLexems
Posted: Tue 13 Aug 2013 08:32
by 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;
Re: Manage OraKeywordLexems
Posted: Tue 03 Sep 2013 20:00
by 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
Re: Manage OraKeywordLexems
Posted: Wed 04 Sep 2013 12:57
by 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