Stored Procedures

From: Marvin <marteaga76_at_my-deja.com>
Date: Thu, 07 Oct 1999 20:06:13 GMT
Message-ID: <7tiufb$7s9$1@nnrp1.deja.com>

In ORACLE can a stored procedure be created such that it returns a query. That is, basically instead of a stored procedure that does INSERTS, UPDATES or DELETES , What I want is really a stored query, a SELECT with a really ugly WHERE caluse that I can pass parameters into. What I don't know is how to get a hold of a query result and pass it back to the caller. Is a stored function that returns a cursor a possibility? Even then how do I throw the cursor back to the issuer of the query?

Help me SQL gods, your my only hope

--
Marvin

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 07 1999 - 15:06:13 CDT