sp_checkOraclepackageversion (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_checkOraclepackageversion(nvarchar @publisher)

MetaData:

   
CREATE PROCEDURE sys.sp_checkOraclepackageversion  
(  
    @publisher          sysname,  
    @versionsmatch      int OUTPUT,  
    @packageversion        nvarchar(256) OUTPUT   
)  
AS  
BEGIN  
    set nocount on  
    DECLARE @cmd nvarchar(4000)  
                ,@retcode int  
                ,@publisher_type sysname  
  
    EXEC @retcode = sys.sp_MSrepl_getpublisherinfo  
        @publisher        = @publisher,  
        @rpcheader        = @cmd OUTPUT,  
        @publisher_type   = @publisher_type OUTPUT,  
        @skipSecurityCheck=1  
    IF @retcode <> 0  
        RETURN (@retcode)  
  
    --  Reject unsupported publisher types  
    IF @publisher_type NOT IN (N'ORACLE', N'ORACLE GATEWAY')  
    BEGIN  
        RAISERROR (21645, 16, -1, @publisher_type)  
        RETURN (1)  
    END                                                                       
  
    SELECT @publisher = UPPER(@publisher)   
            ,@cmd = @cmd + N'sys.sp_MSrepl_checkOraclepackageversion'  
      
    EXEC @retcode = @cmd  
                    @publisher,  
                    @versionsmatch OUTPUT,  
                    @packageversion OUTPUT  
  
    RETURN (@retcode)  
END