Question on default values for Oracle date columns
8 views
Skip to first unread message
ty
Dec 19, 2011, 5:12:22 PM12/19/11
to Rose::DB::Object
what is the proper way to specify a default value of SYSDATE for an
Oracle column of type date?
Oracle column of type date?
I am using:
created => { type => 'date', default => 'SYSDATE', not_null => 1 }
when I try to insert a row without specifying the created value I get
an error complaining about a non-numeric character was found where a
numeric character was expected.
Best regards,
Ty
ty
Dec 20, 2011, 10:09:50 AM12/20/11
to Rose::DB::Object
I figured it out, I had to add the __PACKAGE__->meta-
>allow_inline_column_values(1); to each table object I needed this
for.
>allow_inline_column_values(1); to each table object I needed this
for.
-Tyson
Reply all
Reply to author
Forward
0 new messages