Stored Procedures

From: David Small <102450.3705_at_CompuServe.COM>
Date: 1996/11/11
Message-ID: <5680ar$rde$1_at_mhadf.production.compuserve.com>#1/1


        Can stored procedures return results from a query, much like a VIEW can? What I am looking for is something that can accept parameters (unlike a VIEW), but return results (columns and rows) that can be bound to variables. I have the following stored procedure...  

CREATE PROCEDURE qryGrowth (lSessionID NUMBER)  

BEGIN   SELECT *
FROM tblGrowth
WHERE fldSessionID = lSessionID;  

END qryGrowth;  

When I try to create this procedure, I get a compile error. If I replace the SELECT statement with a DELETE, INSERT, or UPDATE statement, the procedure compiles fine. Is there a way to return a result set?  

Thanks,
Dave
102450,3705_at_CompuServe.Com Received on Mon Nov 11 1996 - 00:00:00 CET

Original text of this message