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 21:32:20 GMT
Hi Henry,

So what the issue? Procedure not created in db?

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


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: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