[rt-users] Oracle CLOB error

[Maria Quinn]

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.