Calling SQL Server SP's from Oracle via Transparent Gateway

From: Chris Downes-Ward <cdownesw_at_inetuk.wang.com>
Date: 1997/08/06
Message-ID: <01bca1b0$abcd3640$6f0f73c1@Kinder.inetuk.wang.com>#1/1

I'm trying to call a Microsoft SQL Server stored procedure from and Oracle server via the transparent gateway. When I try to do this I get the message PLS-00201 dentifier 'procedure name'@'database link' must be declared. I think I have set up the gateway correctly as I have no problems runing queries against tables.

The configuration we have is

Server A

	Sun Sparc station 5
	Solaris CDE Version 1.0.2
	SunOS 5.5.1
	Oracle Server release 7.3.2.3.0 with distributed option

Server B
	Compaq Proliant 1500
	Windows NT 4.0 with service pack 2
	Microsoft SQL Server 6.5 with service pack 3
	Oracle SQL*Net 2.2.2.1.0
	Oracle Transparent Gateway for Microsoft SQL Server 4.0.0.0W

-- 
Chris Downes-Ward
cdownesw_at_inetuk.wang.com

Received on Wed Aug 06 1997 - 00:00:00 CDT