How to produce a result set in a procedure

[Packermann]

I found out that I can call an Oracle procedure from Microsft SQL Server using an OpenQuery function.<br><br>But in order to do this, the Oracle procedure must return a result set. I could not get it to work. I then tried to use a function, which did returned a value, but Oracle would let me put any insert statements in a function.<br><br>So basically, I need to insert into a table and return a value. A procedure can insert and a function can return a value. But I need either a procedure or a function to do both. Can anybody help?<br><br><br><br><br><br>

 

[MikeLacey]

Have you tried calling an Oracle procedure from the function called by SQL Server? <p>Mike<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>Please don't send me email questions without posting them in Tek-Tips as well. Better yet -- Post the question in Tek-Tips and send me a note saying "Have a look at so-and-so in the thingy forum would you?"