ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Henry Lu <z...@umich.edu>
Subject call procedure error
Date Wed, 02 Nov 2005 19:21:36 GMT
Could someone help me out this when I call a procedure in ORACLE:

<procedure id="call_procedure">
 {call set_active_all }
</procedure>

where set_active_all is a prcedure name.

and calling function is:

   public void call_procedure()
   {
      getSqlMapClientTemplate().insert(
             "call_procedure", null);
   }

and errors are:

     [java] org.springframework.jdbc.BadSqlGrammarException: Bad SQL 
grammar [(m
apped statement)] in task 'SqlMapClientTemplate'; nested exception is 
com.ibatis
.common.jdbc.exception.NestedSQLException:
     [java] --- The error occurred in ibatis_map/AccessDB.xml.
     [java] --- The error occurred while applying a parameter map.
     [java] --- Check the call_procedure-InlineParameterMap.
     [java] --- Check the statement (update procedure failed).
     [java] --- Cause: java.sql.SQLException: ORA-06550: line 1, column 7:
     [java] PLS-00201: identifier 'SET_ACTIVE_ALL' must be declared
     [java] ORA-06550: line 1, column 7:
     [java] PL/SQL: Statement ignored

-Henry

Mime
View raw message