Hi Henry, Does the procedure have any IN or OUT parameters?
-----Original Message----- From: Henry Lu [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:22 PM To: [email protected] 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 } </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
