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
