Exec Oracle SP from SQL Server

[InsaneProgrammer]

I am trying to execute a stored procedure in my Oracle Database from within my SQL Database. I have linked the SQL Server to my Oracle Server. The select statement I have below works.

select * from openquery(OrclSvr, 'select * from pa_projects')

But when I try to execute the stored procedure below I get an error.

select * from openquery(OrclSvr, 'execute fnd_client_info.set_org_context(0)')

The error message I get is below.

Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'execute fnd_client_info.set_org_context(0)'. The OLE DB provider 'MSDAORA' indicates that the object has no columns.

The stored procedure executes fine from within SQL*Plus. Any ideas/suggestions would be greatly appreciated.

 

[tlbroadbent]

Check the following links. They describe how to create a wrapper that returns a dummy result set.

http://dbforums.com/archives/t296950.html

http://groups.google.com/groups?selm=#HL4lh2OCHA.1156@tkmsftngp12

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm