Re^2: Error while using Catalyst to insert record to Oracle

The problem seems that primary key ID of BOOKS is not being calculated correctly. And it is supposed to be a incremental process to fetch max ID and increase by 1. However, not finding a clue on tutorial. Though Catalyst tutorial uses SQLite as database, I just try to use Oracle instead.

Comment on Re^2: Error while using Catalyst to insert record to Oracle

Replies are listed 'Best First'.
Re^3: Error while using Catalyst to insert record to Oracle by igelkott (Priest) on Aug 17, 2008 at 18:24 UTC
Oracle uses sequences and triggers, not just a null or zero like some other DB engines. See link for a short discussion. Details can be found in your local Oracle docs but this is at least mentioned in the module description. I started with MySQL (which allows what you tried) and have had to deal with many issues with other DB's. Some people may recommend a higher-level DB interface but I've never used them personally.	[reply]

Replies are listed 'Best First'.

Re^3: Error while using Catalyst to insert record to Oracle
by igelkott (Priest) on Aug 17, 2008 at 18:24 UTC

Oracle uses sequences and triggers, not just a null or zero like some other DB engines. See link for a short discussion. Details can be found in your local Oracle docs but this is at least mentioned in the module description.

I started with MySQL (which allows what you tried) and have had to deal with many issues with other DB's. Some people may recommend a higher-level DB interface but I've never used them personally.

[reply]