OraFAQ Forum: Networking and Gateways » Calling MSSQL Stored procedure

Home » RDBMS Server » Networking and Gateways » Calling MSSQL Stored procedure (Oracle 9i, MSSQL Server 2000, Windows 2003 Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Calling MSSQL Stored procedure [message #323369]

Wed, 28 May 2008 05:43

prasantakb
Messages: 2
Registered: May 2008

Junior Member

Hello All,

I am able to create database connectivity between Oracle 9i and MSSQL Server 2000 using Transparent gateway. Also able to select record from MSSQL Server databse Table by executing select statement in Oracle SQLPlus. But I do not know how to call a MSSQL Stored procedure from Oracle SQLPlus. For example a have stored procedure in MSSQL Server and name of it is suppose 'test'. It receive parameter and do some calculation on received data and send back the result. So how to send data to this stored procedure from Oracle and get back the result in Oracle.I am very new to Oracle. So please help me.

-PK

Report message to a moderator

Previous Topic:	hsodbc on 64bit linux
Next Topic:	tnsping success, sqlplus get ORA-12560 ,here is trace file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 15:57:22 CST 2024