Re: Optional Stored Procedure Parameters

First get the lastest SVN and retry, the IBATISNET-196muste have fixed it. -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Optional Stored Procedure Parameters

I'm having some troubles with stored procedures that have optional parameters. Since our DB team sometime adds parameters to sprocs, but has them optional for backwards compatability, which works, exept in ibatis. I get a ArgumentOutOfRangeException at ParameterPropertyCollection.get_Item when

Re: insert using a stored procedure

You are both showing me how to use the insert element which I already know how to do. I thought stored procedures have to use the procedure element. According to SqlMap.xsd, selectKey is not a valid child element of procedure. On 11/22/06, Senthilmurugan, ANGLER - EIT <[EMAIL PROTECTED]> wrote:

Dot net - Calling stored procedure

Hi, I have the following issues... Model.cs public IList CustOrderReturn() { Hashtable hsh=new Hashtable(); hsh.Add("CustomerId","ALFKI"); return Mapper().QueryForList ("pid_CustOrderHist",hsh); } Webform2.aspx.cs Model mdl=new Model(); //OrderDataGrid.DataSource=mdl.OrderReturn(); Cu

RE: insert using a stored procedure

SELECT STOCKIDSEQUENCE.NEXTVAL AS VALUE FROM DUAL insert into PRODUCT (PRD_ID,PRD_DESCRIPTION) values (#id#,#description#) insert into PRODUCT (PRD_DESCRIPTION) values (#description#) select @@IDENTITY as value insert into PRODUCT (PRD_DESCRIPTION) va

RE: insert using a stored procedure

It depend what database engine you use. Code below is for MySQL Use this code in xml map file under node and after insert query select LAST_INSERT_ID() as value From: Bob Hanson [mailto:[EMAIL PROTECTED