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