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

["Thomas Dudziak (JIRA)" <ji...@apache.org>]

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

Thomas Dudziak commented on DDLUTILS-154:
-----------------------------------------

Are you sure that this happens while DdlUtils runs ? This error is usually caused by issuing an insert/update where one of the input parameter wasn't set, or by a call to a stored procedure where an out parameter was not registered. E.g. 

http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=55&t=000681
http://www.dbmotive.com/oracle_error_codes.php?errcode=17041

AFAIK under certain circumstances, this can confuse the oracle driver so that the error is finally reported during a totally unrelated statement execution.

Please try to execute the DdlUtils statements on their own (e.g. via the Ant tasks) and see whether the error still happens. It would also be helpful if you could supply a XML schema that produces this problem and some info about how you use DdlUtils (e.g. a build file snippet or some code using the DdlUtils API).

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