Return-Path: 
 <user-java-return-4803-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 19820 invoked from network); 2 Nov 2005 19:48:35 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 2 Nov 2005 19:48:35 -0000
Received: (qmail 26157 invoked by uid 500); 2 Nov 2005 19:48:34 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 26143 invoked by uid 500); 2 Nov 2005 19:48:33 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 26132 invoked by uid 99); 2 Nov 2005 19:48:33 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Nov 2005 11:48:33 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [141.211.93.147] (HELO withoutevidence.mr.itd.umich.edu)
 (141.211.93.147)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Nov 2005 11:48:29 -0800
Received: from [141.214.41.53] (host-53.subnet-41.med.umich.edu
 [141.214.41.53])
	by withoutevidence.mr.itd.umich.edu (smtp) with ESMTP id jA2JmCcq020614
	for <user-java@ibatis.apache.org>; Wed, 2 Nov 2005 14:48:12 -0500
Message-ID: <4369186E.1090305@umich.edu>
Date: Wed, 02 Nov 2005 14:50:06 -0500
From: Henry Lu <zhlu@umich.edu>
User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: call procedure error
References: 
 <E016E5505BAB0844BFFF2E03D917CE87221E25@MSGMMKCLQ2WIN.DMN1.FMR.COM>
In-Reply-To: 
 <E016E5505BAB0844BFFF2E03D917CE87221E25@MSGMMKCLQ2WIN.DMN1.FMR.COM>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

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