You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ddlutils-dev@db.apache.org by "Mike Perham (JIRA)" <ji...@apache.org> on 2007/02/07 15:54:05 UTC

[jira] Resolved: (DDLUTILS-154) Autoincrementing columns broken on Oracle10?

     [ https://issues.apache.org/jira/browse/DDLUTILS-154?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mike Perham resolved DDLUTILS-154.
----------------------------------

    Resolution: Invalid

> 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
>    Affects Versions: 1.0
>         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.