|Subject:||missing text lob type in DBIx::Class::Storage::DBI|
|Date:||Mon, 22 Jul 2013 16:43:07 +0200|
|To:||"'bug-DBIx-Class [...] rt.cpan.org'" <bug-DBIx-Class [...] rt.cpan.org>|
|From:||Jonathan Stowe <jonathan.stowe [...] db.com>|
Classification: Public Hi, In DBIx::Class::Storage::DBI the method _is_lob_type has $data_type && ($data_type =~ /lob|bfile|text|image|bytea|memo/i And the _is_text_lob_type has $data_type && ($data_type =~ /^(?:clob|memo)\z/i Whereas I suspect that it should be: $data_type && ($data_type =~ /^(?:clob|memo|text)\z/i On Oracle assuming that we have relied on SQL::Translator to do translate a column defined as "text" to "clob" in the schema (which it does, ) this will result in: DBI Exception: DBD::Oracle::st execute failed: ORA-00932: inconsistent datatypes: expected CLOB got BLOB.. because the ora_type is being set incorrectly in the bind_params in DBIx::Class::Storage::DBI::Oracle::Generic (it defaults to ORA_BLOB .) Thanks. --- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Please refer tofor additional EU corporate and regulatory disclosures.