From: Jason Lisenchuk <hris@nt.com>
Newsgroups: comp.databases.oracle
Subject: Re: Question on How to call a Select stmt in a Stored Procedure ?
Date: 9 Sep 1994 18:45:42 GMT
Organization: Northern Telecom - Bell Northern Research
Lines: 16
Distribution: world
Message-ID: <34qagn$ov4@bmerha64.bnr.ca>
References: <34niog$559@bcarh8ab.bnr.ca>
NNTP-Posting-Host: 47.169.5.141
X-Newsreader: Nuntius Version 1.2
X-XXDate: Fri, 9 Sep 1994 14:50:52 GMT


Question on How to call a Select stmt in a Stored Procedure ?

Please keep in mind that Oracle 7.0.x stored procedures cannot return a
cursor; instead return a scalar value (like NUMBER or VARCHAR or LONG). 
If the SELECT contained within the procedure retrieves a small amount of
data, you could consider packing this into a LONG (with appropriate
delimiters) and parsing via C at the client.  Alternatively, you could
use the SELECT to summarize data and INSERT it into another table, which
you SELECT and FETCH via C at the client.

I am hopeful that this will be fixed in a future version of Oracle.  I
would also like to be able to call a C module from within a stored
procedure.

Jason Lisenchuk
ESN 334-7879