Hi, I'm using Ibatis SQL Map to call stored procedure in Oracle, I got this error when calling the procedure

--- The error occurred in conf/Query.xml.
--- The error occurred while applying a parameter map.
--- Check the queries.single-rs-all.
--- Check the statement (update procedure failed).
--- Cause: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'CONT_ORDER_INS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

The procedure compiled and executed successfully, I'm using modified Ibatis Sqlmap for Oracle Cursor Ref (works with previous project).

Here's the sql map I used :

<sqlMap namespace="queries">
<typeAlias alias="ContentOrder" type="content.valueobjects.ContentOrder" />

    <parameterMap id="single-rs-all" class="map">
        <parameter property="in1" jdbcType="VARCHAR" mode="IN"/>
        <parameter property="in2" jdbcType="VARCHAR" mode="IN"/>
        <parameter property="in3" jdbcType="VARCHAR" mode="IN"/>
        <parameter property="in4" jdbcType="VARCHAR" mode="IN"/>
        <parameter property="in5" jdbcType="VARCHAR" mode="IN"/>
        <parameter property="in6" jdbcType="VARCHAR" mode="IN"/>
        <parameter property="in7" jdbcType="VARCHAR" mode="IN"/>
        <parameter property="in8" jdbcType="VARCHAR" mode="IN"/>
        <parameter property="in9" jdbcType="VARCHAR" mode="IN"/>
        <parameter property="in10" jdbcType="VARCHAR" mode="IN"/>
        <parameter property="in11" jdbcType="VARCHAR" mode="IN"/>
        <parameter property="in12" jdbcType="VARCHAR" mode="IN"/>
        <parameter property="output1" jdbcType="ORACLECURSOR" mode="OUT"/>
    </parameterMap>

    <resultMap id="content-order-map" class="ContentOrder">
        <result property="contentOrderId" column="contentOrderId" />
    </resultMap>

<procedure id="insertContOrder" parameterMap="single-rs-all" resultMap="content-order-map">
        { call cont_order_ins(?,?,?,?,?,?,?,?,?,?,?,?,?) }
    </procedure>
</sqlmap>

--
Regards,
Hendry

Reply via email to