X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=dump_oracle_table_for_pg;fp=dump_oracle_table_for_pg;h=93a2312f5c6e65dcf38a335c35ebe68b3ecd9071;hp=116c0054322b310f9eab4bc878bc8ce9d074142c;hb=b7717b892d1f4c690baf55d680688b44492780f7;hpb=07a1454d9162950c16e98347c13a64c3d8f60efb

diff --git a/dump_oracle_table_for_pg b/dump_oracle_table_for_pg
index 116c005..93a2312 100755
--- a/dump_oracle_table_for_pg
+++ b/dump_oracle_table_for_pg
@@ -150,7 +150,7 @@ sub get_pg_column_type {
         if ($column_def->{DATA_SCALE} == 0) {
             $type = 'INTEGER';
         } else {
-            $type = "NUMBER($column_def->{DATA_PRECISION},$column_def->{DATA_SCALE})";
+            $type = "NUMERIC($column_def->{DATA_PRECISION},$column_def->{DATA_SCALE})";
         }
     }
     if (defined $type) {