r500776 | eross | 2007-01-28 04:44:27 -0600 (Sun, 28 Jan 2007) | 1 line

Bug 28908 - Retest SQL and clean up trigger

Index: src/java/org/apache/log4j/db/dialect/oracle.sql
===================================================================
6a7
> -- Tested successfully on Oracle9i Release by Elias Ross
16d16
<
28c28
<     reference_flag    SMALLINT,
---
>     reference_flag    NUMBER(5),
36,37c36
<
< CREATE TRIGGER logging_event_id_seq_trig
---
> CREATE OR REPLACE TRIGGER logging_event_id_seq_trig
41,45c40,42
<     SELECT logging_event_id_seq.NEXTVAL
<     INTO   :NEW.event_id
<     FROM   DUAL;
<   END logging_event_id_seq_trig;
<
---
>    SELECT logging_event_id_seq.nextval
>    INTO :new.sequence_number$ FROM dual
> END;
59c56
<     i                SMALLINT NOT NULL,
---
>     i                NUMBER(5)  NOT NULL,
65,67d61
<
<
<


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to