IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Trigger creation error using 10g driver

  • 1.  Trigger creation error using 10g driver

    Posted Fri December 07, 2007 07:36 PM

    When running a JDBC adapter service that creates a trigger, the following error is returned by Oracle:

    (17041) Missing IN or OUT parameter at index:: 1

    In search the web for possible causes/solutions, came across this link:

    [URL=“http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/readme_10201.html”]http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/readme_10201.html[/URL]

    In the “Known Problems/Limitations In This Release” section it states:

    “Limitation on using PreparedStatements to create triggers. Since
    :foo is recognized by the drivers as a SQL parameter, it is not
    possible to use :in and :out in SQL that defines a trigger when
    using a PreparedStatement. The workaround is to use a Statement
    instead.”

    We’re using :new and :old but the limitation would still seem to apply.

    The template being used is CustomSQL. JDBC Adapter 6.0.3 FP1.

    wM support says there is nothing they can do as this is really a driver bug.

    We can externalize the trigger creation but we’re hoping that someone else may have encountered this issue and perhaps have solved it in some way. If so, if you’d be able to share the solution it would be much appreciated.


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


Related Content