[rt-users] Question about RT2 and Oracle

[Alex Rolfe]

> I have been asked to find out how well and stable does RT2.0.4 work and play
> with Oracle? any version at this point.

I've been using it on Oracle and it seems ok, though I haven't used it
all that heavily.

You may need to tweak the schema during the install (though it's been a
while since I installed and the schema may have been updated since
then).

The one problem that I have observed is that the DBIx::SearchBuilder
attempts to build SQL statements that don't work on Oracle because they
include a LIMIT clause.  If you modify the _LimitClause method in
SearchBuilder.pm to return an empty string (rather than whatever clause
it would have), then RT works (though you get more than the 25 results
it claims to give you in some cases).

Alex