Home » RDBMS Server » Networking and Gateways » Calling MSSQL Stored procedure (Oracle 9i, MSSQL Server 2000, Windows 2003 Server)
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
Previous Topic: hsodbc on 64bit linux
Next Topic: tnsping success, sqlplus get ORA-12560 ,here is trace file
Goto Forum:
  


Current Time: Fri Mar 29 08:03:38 CDT 2024