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/26 19:08:30 UTC
[jira] Commented: (IBATISNET-165) Getting return value
generatedKeys from stored procedures in inserts
[ http://issues.apache.org/jira/browse/IBATISNET-165?page=comments#action_12417843 ]
Gilles Bayon commented on IBATISNET-165:
----------------------------------------
You can retrieve it with an output parameter
CREATE PROCEDURE dbo.[ps_InsertCategorie]
@Category_Id [int] output,
@Category_Name [varchar] (32),
@Category_Guid [uniqueidentifier]
AS
insert into Categories
(Category_Name, Category_Guid )
values
(@Category_Name, @Category_Guid)
SELECT @Category_Id = SCOPE_IDENTITY()
> 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
>
> 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