I have the following Stored Procedure setup in SQL 7:

CREATE PROC spGetNextID
@TableName sysname,
@NextID int OUTPUT
AS
SET NOCOUNT ON
BEGIN TRAN
    UPDATE IdTable SET NextID = NextID + 1
        WHERE TableName = @TableName
    SET @NextID = (SELECT NextID-1 FROM IdTable
                                WHERE TableName = @TableName)
COMMIT TRAN

When I call the procedure the following error message appears: Multiple
Step OLE DB operation generates errors.  Check each OLE DB values if
avaliable.  What am I doing wrong?

Thanks

Jeff