Autoincrementing columns broken on Oracle10?
--------------------------------------------

                 Key: DDLUTILS-154
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-154
             Project: DdlUtils
          Issue Type: Bug
          Components: Core - Oracle
         Environment: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
            Reporter: Mike Perham
         Assigned To: Thomas Dudziak


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;;


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to