-- Name:
--          sp_ORArowcount

-- Description:
--          Record row count entry in HREPL events

-- Security:
--          Internal

-- Returns:
--          Success/failure

-- Owner:
--          

CREATE PROCEDURE sys.sp_ORArowcount
(
	@publisher			sysname,
	@owner				sysname,
	@table				sysname,
	@publicationid		int,
	@articleid			int,
	@command_type		int,
	@command			nvarchar(4000),
	@subscription_level	bit
)
AS
BEGIN
	declare @OracleCommand	nvarchar(4000),
			@retcode		int

	SET @retcode = 0

	SET NOCOUNT ON


	create table #hquery
	(
		seq	int identity(2,1),
		cmd	nvarchar(4000)
	)
	
	-- Build command
	INSERT INTO #hquery (cmd) VALUES (N'{call HREPL.RowCnt(')
	INSERT INTO #hquery (cmd) VALUES (QUOTENAME(@owner, '''') + N',')
	INSERT INTO #hquery (cmd) VALUES (QUOTENAME(@table, '''') + N',')
	INSERT INTO #hquery (cmd) VALUES (CONVERT(varchar(10),@publicationid) + N',')
	INSERT INTO #hquery (cmd) VALUES (CONVERT(varchar(10),@articleid) + N',')
	INSERT INTO #hquery (cmd) VALUES (CONVERT(varchar(10),@command_type) + N',')
	INSERT INTO #hquery (cmd) VALUES (sys.fn_replquotename(@command, '''') + N',')
	INSERT INTO #hquery (cmd) VALUES (CONVERT(nvarchar(10), @subscription_level) + N')}')
	EXEC @retcode = sys.sp_IHquery @publisher

	IF  (@@error <> 0 OR @retcode <> 0 )
	BEGIN
		RAISERROR (21651, 16, -1, 'RowCnt', @publisher)
    	RETURN (1)
	END
END