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] Updated: (DDLUTILS-154) Autoincrementing columns broken on Oracle10?
Date Tue, 06 Feb 2007 23:26:06 GMT

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

Mike Perham updated DDLUTILS-154:
---------------------------------

    Affects Version/s: 1.0

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


Mime
View raw message