db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-154) Autoincrementing columns broken on Oracle10?
Date Wed, 07 Feb 2007 06:37:05 GMT

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


Mime
View raw message