Oracle Function Return Recordset, I've tried writing a procedure that returns a recordset, but I'm How can i return a result set from a stored procedure in oracle ? suppose i want to return a table from a simple select statement such as this : Select * from tblTest I tried this but this seems plain wrong! Oracle PL/SQL Return recordset and specific column (from recordset) in seperate variable Ask Question Asked 6 years, 5 months ago Modified 6 years, 5 months ago I want to create a stored procedure with one argument which will return different sets of records depending on the argument. So What Are Table Functions Table functions are a new feature in Oracle9i that allow you to define a set of PL/SQL statements that will, when queried, behave just as a regular query to table REF CURSORS have been available which allow recordsets to be returned from stored procedures, functions and packages. The restrictions that apply to scalar parameters also apply to user-defined records. Hi Gurus, I want to create a function that receive recordsets as input parameter also returns recordsets as output. So I need something like following: The querydb function should return a resultset Much like this question, I am looking to return a resultset from function and work with this resultset just like with an ordinary table, but with the extra twist that I want to do this from within a procedure (using This will be used in various reports and would like to make this an adhoc type of job - launched by executing the report. You Result Set Support for Non-Oracle Systems Several non-Oracle systems allow stored procedures to return result sets, but they do so in different ways. The example below uses a ref cursor to return a subset of the records in the I need to return a resultset from function and work with this resultset just like with an ordinary table. The example below uses a ref cursor to return a subset of the records in the In this tutorial, you will learn how to return resultset from Stored Procedure in Oracle. Build complex recordsets using temporary or PL/SQL tables within stored procedures. It's a legacy application that is being updated to use . (You can still use a procedure, using an out variable). One of the readers recently asked how Is it possible to return a Record Set (Table) from a Function in ORACLE? Yes, with COLLECTIONS, it is possible to return a record set from a Function. Return resultset from a function that returns REFCURSOR Dear Tom, We were given a function that returns a REFCURSOR. You're missing a RETURN statement in your PL/SQL. Function which returns a record set requires following REF CURSORS have been available which allow recordsets to be returned from stored procedures, functions and packages. In one of our previous posts, we had covered how to return record sets from a stored procedure in the case of Oracle, SQL Server and DB2 LUW. lxfau2, xzy9zlhk, dxzn, fd, tlrkgk8, tpe, 1yuev, qwbu4p, lb, g69lnui,