Re: Output Parameters in Stored Procedures

[Gilles Bayon]

You should use ExecuteInsert

/// <summary>
/// Execute an insert statement. Fill the parameter object with
/// the ouput parameters if any, also could return the insert generated key
/// </summary>
/// <param name="session"> The session</param>
/// <param name="parameterObject"> The parameter object used to fill the statement.</param>
/// <returns>Can return the insert generated key.</returns>
object ExecuteInsert(IDalSession session, object parameterObject );

Here a sample from Nunit test

Category category = new Category();
category.Name = "Mapping object relational";
sqlMap.Insert("InsertCategoryViaStoreProcedure" , category);
Assert.AreEqual(1, category.Id );

<

procedure id=" InsertCategoryViaStoreProcedure" parameterMap=" insert-params">
ps_InsertCategorie
</ procedure>

 

<

parameterMap id=" insert-params">
<parameter property ="Id" column ="Category_Id" dbType ="Int" />
< parameter property=" Name" column="Category_Name "/>
<parameter property ="Guid" column= "Category_Guid" dbType ="UniqueIdentifier"/>
</ parameterMap>it is for SQL Server but you will find the same example for Oracle