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:40:07 GMT
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:zhlu@umich.edu] 
Sent: Wednesday, November 02, 2005 2:26 PM
To: user-java@ibatis.apache.org
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: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 }
></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