[rt-users] Oracle CLOB error

[Maria Quinn]

Thanks, Ruslan.

I've checked the release notes for 3.8.3 and I'm 
can't see this fix.  Can anyone confirm if it is actually in there.

Regards,

Maria

At 16:27 04/06/2009, Ruslan Zakirov wrote:
>I think it's been fixed in 3.8.3
>
>On Thu, Jun 4, 2009 at 7:05 PM, Maria Quinn <mail at mariaquinn.com> wrote:
> > I've installed RT 3.8.2 on Redhat 4.1.2 with Oracle and DBD::Oracle 1.2.2.
> >
> > I'm getting the following errors in /var/log/messages as a result of
> > forwarding a ticket:
> >
> > Jun  4 12:48:35 vbchwebt RT: DBD::Oracle::db prepare failed:
> > ORA-00932: inconsistent datatypes: expected - got CLOB (DBD ERROR:
> > error possibly near <* Â  Â  Â  Â  Â > indicator at char 44 in 'SELECT
> > main.* FROM Attachments main  WHERE (<*>main.Content != '') AND
> > (main.TransactionId = '26') AND (main.id != '1')
> > AND Â  Â  Â  Â  Â  (main.ContentType NOT LIKE 'multipart/%') Â ORDER BY
> > main.id ASC ') [for Statement "SELECT main.* FROM Attachments
> > main  WHERE (main.Content != '') AN          D (main.TransactionId =
> > '26') AND (main.id != '1') AND (main.ContentType NOT LIKE
> > 'multipart/%') Â ORDER BY main.id ASC "] at
> > /usr/lib/perl5/site_perl/ Â  Â  Â  Â  Â 5.8.8/DBIx/SearchBuilder/Handle.pm
> > line 469, <GEN33> line 42.
> > (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:469)
> > Jun  4 12:48:35 vbchwebt RT: RT::Handle=HASH(0x83c95f0) couldn't
> > prepare the query 'SELECT main.* FROM Attachments main  WHERE
> > (main.Content != '') AN Â  Â  Â  Â  Â D (main.TransactionId = '26') AND
> > (main.id != '1') AND (main.ContentType NOT LIKE 'multipart/%') Â ORDER
> > BY main.id ASC 'ORA-00932: inconsistent dataty          pes: expected
> > - got CLOB (DBD ERROR: error possibly near <*> indicator at char 44
> > in 'SELECT main.* FROM Attachments main  WHERE (<*>main.Content !=
> > ' Â  Â  Â  Â  Â ') AND (main.TransactionId = '26') AND (main.id != '1')
> > AND (main.ContentType NOT LIKE 'multipart/%') Â ORDER BY main.id ASC
> > ') (/usr/lib/perl5/site_pe          
> rl/5.8.8/DBIx/SearchBuilder/Handle.pm:476)
> >
> > As far as I understand, it's not possible to select from a CLOB
> > column in Oracle, so I'm wondering if I've 
> got a misconfiguration somewhere.
> >
> > I haven't seen any errors in the front end relating to this, but I
> > still have some unresolved issues configuring mail, which I'm also
> > working on, so I'm still not clear what the extent of this problem is.
> >
> > Thanks in advance for any advice.
> >
> >
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Community help: http://wiki.bestpractical.com
> > Commercial support: sales at bestpractical.com
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
> >
>
>
>
>--
>Best regards, Ruslan.
>
>No virus found in this incoming message.
>Checked by AVG - www.avg.com
>Version: 8.5.339 / Virus Database: 
>270.12.53/2154 - Release Date: 06/04/09 05:53:00