You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Gilles Bayon (JIRA)" <ib...@incubator.apache.org> on 2006/06/27 21:03:30 UTC

[jira] Closed: (IBATISNET-165) Getting return value generatedKeys from stored procedures in inserts

     [ http://issues.apache.org/jira/browse/IBATISNET-165?page=all ]
     
Gilles Bayon closed IBATISNET-165:
----------------------------------

    Fix Version: DataMapper 1.5
     Resolution: Fixed

In SVN

> Getting return value generatedKeys from stored procedures in inserts
> --------------------------------------------------------------------
>
>          Key: IBATISNET-165
>          URL: http://issues.apache.org/jira/browse/IBATISNET-165
>      Project: iBatis for .NET
>         Type: Improvement

>   Components: DataMapper
>     Versions: DataAccess 1.5
>  Environment: .net framework 2.0
>     Reporter: Oddur Magnusson
>      Fix For: DataMapper 1.5
>  Attachments: MappedStatement.cs.patch, category-procedureWithReturn.sql, complete.patch, procedure.cs.patch
>
> When calling a stored procedure that does a insert and returns the row idendity in a return statement, like
> CREATE PROCEDURE [dbo].[DoFoo]  @foo int AS
> INSERT INTO Foos (foo) VALUES (@foo)
> RETURN @@IDENTITY
> there is no way of accessing the return value and returning it as the generatedKey

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira