Re: java.sql.SQLException: ORA-06550: line 1, column 7:,PLS-00201: identifier 'CONT_ORDER_INS' must be declared

[Clinton Begin]

Try specifying the owning schema. The error suggests that it can't find the
proc.

Clinton

On 3/19/07, Hendry <[EMAIL PROTECTED]> wrote:

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