#56 Need to allow alternate command delimeter

[Ken Sheldon]

Oracle PL-SQL requires the use of semicolons in SQL.

Consider the following:

create or replace trigger TIAPP_MENU
before insert on APP_MENU
for each row begin
if :new.APP_MENU_ID is null then
select SEQ_APP_MENU.nextval
into :new.APP_MENU_ID from dual ;
end if; end TIAPP_MENU ;

The semicolons are required. Without them, the trigger
will fail to compile.

JFaceDbc treats the semicolon as a command delimeter,
and the resulting SQL fragments are not valid.

Triggers or procedures like this have to be created
outside JFaceDbc.

I think we need a way to specify an alternate command
delimiter. The delimeter need not be a single character.
(SQL clients for Sybase, MSSQL, and MDI use the word
GO as a command delimiter, but they allow alternate
delimiters, like CR+LF)

[Andrea Mazzolini]

Logged In: YES
user_id=556246

You are right. Anyway if you want to create a trigger for
Oracle, I suggest you to consider the "Create a new trigger"
functionality. Just right-click on the Trigger node of any
schema.