User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle - Returning Result Sets from Stored Procedures
You can use the OPEN cursor statement and refcursor OUT parameter to return a result set from a PL/SQL stored procedure.
Example:
CREATE OR REPLACE PROCEDURE GetOrderInfo(v_data IN NUMBER, v_refcur OUT SYS_REFCURSOR) AS BEGIN OPEN v_refcur FOR SELECT * FROM dbo.OrderInfo WHERE data = v_data; END;
Returning Result Sets - Differences between Oracle and other Databases
Database | Returning Result Sets |
---|---|
SQL Server | SQL Server Result Sets - Standalone SELECT statement |