Re: Stored Procedures

David Small wrote:
>
> 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
Try using the DBMS_SQL package page 5-7 in the PL/SQL users guide. Received on Tue Nov 19 1996 - 00:00:00 CET