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
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 *
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?
FROM tblGrowth
WHERE fldSessionID = lSessionID;
Thanks,
Dave
102450,3705_at_CompuServe.Com
Received on Mon Nov 11 1996 - 00:00:00 CET