-- 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