ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rao, Satish" <satish....@fmr.com>
Subject RE: call procedure error
Date Wed, 02 Nov 2005 19:22:36 GMT
Hi Henry,

Does the procedure have any IN or OUT parameters?

-----Original Message-----
From: Henry Lu [mailto:zhlu@umich.edu] 
Sent: Wednesday, November 02, 2005 2:22 PM
To: user-java@ibatis.apache.org
Subject: call procedure error

Could someone help me out this when I call a procedure in ORACLE:

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

where set_active_all is a prcedure name.

and calling function is:

   public void call_procedure()
             "call_procedure", null);

and errors are:

     [java] org.springframework.jdbc.BadSqlGrammarException: Bad SQL 
grammar [(m
apped statement)] in task 'SqlMapClientTemplate'; nested exception is 
     [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
     [java] PLS-00201: identifier 'SET_ACTIVE_ALL' must be declared
     [java] ORA-06550: line 1, column 7:
     [java] PL/SQL: Statement ignored


View raw message