Thank you very much to remind me. I made stupid mistakes.
-Henry
Rao, Satish wrote:
Hi Henry,
I am not sure... But from the error you are getting, it seems the
procedure is not created in the database.
Did you try executing the procedure via SQL Plus?
-----Original Message-----
From: Henry Lu [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 02, 2005 2:26 PM
To: [email protected]
Subject: Re: call procedure error
No, not all.
-Henry
Rao, Satish wrote:
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
