CREATE PROCEDURE sys.sp_MSrepl_setOraclepackageversion
(
    @publisher          sysname
)
AS
BEGIN
    set nocount on
    DECLARE @retcode            int
    DECLARE @version            nvarchar(256)

    -- Security check.  'sysadmin' or db_owner of distribution db required.
    EXEC @retcode = sys.sp_MSreplcheck_publish
    IF @@ERROR <> 0 or @retcode <> 0
        RETURN (1)

    -- Set version string from SERVERPROPERTY
    SET @version = N'Microsoft SQL Server ' +  convert(nvarchar(100),SERVERPROPERTY('ProductLevel')) +
		+ N' Version:' + convert(nvarchar(100),SERVERPROPERTY('ProductVersion'))

    -- Define sp_ORAremotequery support table
    create table #hquery
    (
        seq	int identity(2,1),
        cmd	nvarchar(4000)
    )

    -- Set the package version
    INSERT INTO #hquery(cmd) VALUES (N'UPDATE HREPL_VERSION SET SQLSERVERVERSION = ' + sys.fn_replquotename(@version, ''''))

    EXEC @retcode = sys.sp_IHquery @publisher
	
    IF  (@@error <> 0 OR @retcode <> 0 )
    BEGIN
        DROP TABLE #hquery
        RETURN (1)
    END
	
    DROP TABLE #hquery

    RETURN (0)
END