db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Perham (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-154) Autoincrementing columns broken on Oracle10?
Date Tue, 06 Feb 2007 23:26:05 GMT
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.


Mime
View raw message