X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F14ora_common.t;h=2cd05b5a7d98789995bccdfcb391a7a6566765d7;hb=804c115dd211c89d1ab9317ee12b2af6063164b9;hp=75bd98cdc54fa45f278f87c2e86e4825cc61745d;hpb=78b7ccaaaff070d6053dda2843007369d7501662;p=dbsrgits%2FDBIx-Class-Schema-Loader.git

diff --git a/t/14ora_common.t b/t/14ora_common.t
index 75bd98c..2cd05b5 100644
--- a/t/14ora_common.t
+++ b/t/14ora_common.t
@@ -8,11 +8,28 @@ my $password = $ENV{DBICTEST_ORA_PASS} || '';
 
 my $tester = dbixcsl_common_tests->new(
     vendor      => 'Oracle',
-    auto_inc_pk => 'SERIAL NOT NULL PRIMARY KEY',
+    auto_inc_pk => 'INTEGER NOT NULL PRIMARY KEY',
+    auto_inc_cb => sub {
+        my ($table, $col) = @_;
+        return (
+            qq{ CREATE SEQUENCE ${table}_${col}_seq START WITH 1 INCREMENT BY 1},
+            qq{ 
+                CREATE OR REPLACE TRIGGER ${table}_${col}_trigger
+                BEFORE INSERT ON ${table}
+                FOR EACH ROW
+                BEGIN
+                    SELECT ${table}_${col}_seq.nextval INTO :NEW.${col} FROM dual;
+                END;
+            }
+        );
+    },
+    auto_inc_drop_cb => sub {
+        my ($table, $col) = @_;
+        return qq{ DROP SEQUENCE ${table}_${col}_seq };
+    },
     dsn         => $dsn,
     user        => $user,
     password    => $password,
-    no_auto_increment => 1,
 );
 
 if( !$dsn || !$user ) {