Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abderahim82
Starting Member
1 Post |
 Posted - 2009-06-15 : 11:07:31
|
| Hello,I use a TG4MSQL gateway between an oracle client 9i and Sqlserevr 2005,from sqlplus of the oracle machine, I call the stored procedures of the machine hosting sqlserver,I want to recover the SqlServer display in my sqlplus client,I give an example:if I'm using sqlserver and that I execute my stored procedure: Infoserv () -> I see the informations of my server in sqlserverNow, if I execute the same procedure on the Oracle machine I get the message:"Procedure Plsql is completed successfully" but no output in the console sqlplus (sqlplus dont show me the informations of my server)So my question is:Is it possible to redirect the display of an sqlserver stored procedure in the sqlplus console via a Gateway?If not possible, would there be a way to get divert this problem.thank you in advance |
|
|
|
|
|
Displaying the result of a stored procedure via