April 17, 2012

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

No comments:

Post a Comment

Total Pageviews