re: Step by Step Procedure to Implement SQL Server Transactional Replication with Oracle as Publisher

How to add article to existing replication? — Sun, 10 Mar 2013 04:34:48 GMT

How to add article to existing replication?

re: Step by Step Procedure to Implement SQL Server Transactional Replication with Oracle as Publisher

Radovan Cisar — Wed, 23 Sep 2009 11:18:58 GMT

call oracle procedure (function) via linked server and get its result (return value)

<pre>

--input parameters p1, p2, p3

declare @SQL nvarchar(1000)

declare @param nvarchar(100)

declare @result varchar(20) -- numbers may cause data type error

-- (...custom actions, i.e. insert to local table)

set @SQL = N'set @result = (select * from openquery(myLinkedServer, ''select OwnerName.Function_Insert(' + cast(@p1 as varchar) + ', ' + cast(@p1 as varchar) + ', ' + cast(@p3 as varchar) + ') from dual''))'

set @param = '@result varchar output'

EXEC sp_executesql @SQL, @param, @result output

if @result <> '0' goto ERROR

-- (...custom actions)

return 1 -- OK

ERROR:

-- (...custom actions, i.e. delete from local table with(rowlock))

return 0 -- KO

</pre>

Microsoft SQL Server Tips amp Tricks Step by Step Procedure to | unemployment office

Tue, 16 Jun 2009 10:55:56 GMT

PingBack from http://unemploymentofficeresource.info/story.php?id=14689