ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: java.sql.SQLException: ORA-06550: line 1, column 7:,PLS-00201: identifier 'CONT_ORDER_INS' must be declared
Date Tue, 20 Mar 2007 05:28:37 GMT
Try specifying the owning schema. The error suggests that it can't find the
proc.

Clinton

On 3/19/07, Hendry <hendry.hu@elasitas.com> 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
>

Mime
View raw message