Hi Henry, So what the issue? Procedure not created in db?
-----Original Message----- From: Henry Lu [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:50 PM To: [email protected] 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:[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 >> >> >> >> >> >> > > > >
