| Subject: | SQL::Translator::Producer::Oracle - CREATE TABLE failed |
Hi,
I had to remove ";" from "CREATE TABLE" constructor to make it work for me:
--- Oracle.pm.orig 2008-02-28 23:36:18.000000000 +0100
+++ Oracle.pm 2008-05-30 15:33:14.000000000 +0200
@@ -515,7 +515,7 @@
? "\n".join("\n", @table_options) : '';
push @create, "CREATE TABLE $table_name_ur (\n" .
join( ",\n", map { " $_" } @field_defs, @constraint_defs ) .
- "\n)$table_options;";
+ "\n)$table_options";
if ( $WARN ) {
if ( %truncated ) {
Otherwise I was getting:
DBI Exception: DBD::Oracle::db do failed: ORA-00911: invalid character
(DBD ERROR: error possibly near <*> indicator at char 156 in 'CREATE
TABLE timestamp_test (
timestamp_test_id number NOT NULL,
ts date,
tstz timestamp with time zone,
d date,
PRIMARY KEY (timestamp_test_id)
)<*>;') [for Statement "CREATE TABLE timestamp_test (
timestamp_test_id number NOT NULL,
ts date,
tstz timestamp with time zone,
d date,
PRIMARY KEY (timestamp_test_id)
);"] at lib/DBIx/Class/Schema.pm line 1011
The ; should not be there but I'm not sure that I've removed it on the
right place...
Regards,
Jozef.