[Catalyst] ok against sqlite. Not working against Oracle81.Sequence problem.

[Garrett, Philip (MAN-Corporate)]

> -----Original Message-----
> From: catalyst-bounces at lists.rawmode.org
[mailto:catalyst-bounces at lists.rawmode.org] On Behalf Of David Rio
Deiros
> Sent: Monday, March 06, 2006 3:04 PM
> To: catalyst at lists.rawmode.org
> Subject: [Catalyst] ok against sqlite. Not working against
Oracle81.Sequence problem.
> 
> Hi there,
> 
> I am still on my Quest to make my first serious catalyst application
to
> run on a solaris machine (Oracle 8.1 as a Database Engine).
> 
[snip]
> 
> iCaught exception in radio_advertising::Controller::Contest->do_add
> "DBD::Oracle::db prepare_cached failed: ORA-00923: FROM keyword not
> found where expected (DBD ERROR: error possibly near <*> indicator at
> char 34 in 'SELECT NEXTVAL ('contest_id_seq') <*>') [for Statement
> "SELECT NEXTVAL ('contest_id_seq') "] at
> /usr/local/lib/perl5/site_perl/5.8.3/Ima/DBI.pm line 381."

You should install Class::DBI::Oracle, which solves this problem.
After you install it, change your classes to inherit from it instead of
Class::DBI.

Philip