| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Returning resultsets from Oracle Stored procedures???
Are Oracle stored procedures able to return a result set to the calling applications(ie. a VB app)?
I'm trying to retrieve rows without embedding or dynamically building the Select statement. I have used stored procedures to do this in SQL Server and Sybase, but I am having problems doing this in Oracle.
This is an example of the SP that I'm trying to use. I am having errors when I try to create it.
CREATE PROCEDURE SelEmp
As
BEGIN
Select * From employee Order By last_name;
END;
Help me please!!!
Lee Received on Tue Dec 10 1996 - 00:00:00 CST
 |
 |