Mario
Mario

Reputation: 1

Oracle Data Modeler Table/Trigger DDL Script previews

i notice that this row inside the body of a trigger

V_SYSTIMESTAMP TIMESTAMP(6) DEFAULT SYSTIMESTAMP;

wrote in this place of the script, between the DECLARE and BEGIN keyword

DECLARE
V_SYSTIMESTAMP TIMESTAMP(6) DEFAULT SYSTIMESTAMP;
BEGIN
.....
END;

caused some problem for the indentation when i display the DDL script preview for the table. Inside that script i see the trigger section write without indentation and new lines.

if i declare V_SYSTIMESTAMP otherwise like

V_SYSTIMESTAMP NUMBER;

i don't have the same problem during the preview.

The display of the DDL preview for only the trigger is right.

an example if i declare number var:

CREATE OR REPLACE TRIGGER ARC.TRG322 BEFORE
INSERT OR UPDATE ON ARC.TABLE
FOR EACH ROW
DECLARE
A NUMBER;
BEGIN
NULL;
END;

if i use timestamp i have this, boby write in one row

CREATE OR REPLACE TRIGGER ARC.Trg322
BEFORE INSERT OR UPDATE ON ARC.TABLE
FOR EACH ROW DECLARE
A TIMESTAMP;
BEGIN NULL ; END ;

thanks;

Upvotes: 0

Views: 155

Answers (0)

Related Questions