Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Returning resultsets with Oracle Stored procedures

Re: Returning resultsets with Oracle Stored procedures

From: David Russell <user_at_msn.com>
Date: 1997/11/29
Message-ID: <01bcfce7$ab850e00$ab4195c1@thor>#1/1 







For non Oracle Clients you can use 3 stored procedures in a package :



procedure one defines the cursor 


procedure two fetches rows from the cursor
procedure three closes the cursor



This is all a bit messy, so why not use Oracle Objects for OLE, it is able
to read out arguments from stored procedures that are of type : PL/SQL
Table of Records. The only other option is to resort to Pro*C or OCI.



Regards


David Russell
Received on Sat Nov 29 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US