[DDLUTILS-154] Autoincrementing columns broken on Oracle10?

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.0
• Component/s: Core - Oracle
• Environment: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
• Assignee: Thomas Dudziak
• Reporter: Mike Perham
• Created: 06/Feb/07 23:25
• Updated: 07/Feb/07 14:52
• Resolved: 07/Feb/07 14:52

Description

java.lang.RuntimeException: Unable to execute SQL with message 'Missing IN or OUT parameter at index:: 1' and code 17041/null:

CREATE OR REPLACE TRIGGER trg_w_inboxmsg_id BEFORE INSERT ON w_inboxmsg FOR EACH ROW WHEN (new.id IS NULL)
BEGIN SELECT seq_w_inboxmsg_id.nextval INTO :new.id FROM dual; END;;