一个例子：

DECLARE  C1 SYS_REFCURSOR;BEGIN  OPEN C1 FOR    SELECT Msi.Organization_Id,           Msi.Inventory_Item_Id,           Msi.Segment1,           CURSOR (SELECT Ood.Organization_Id,                          Ood.Organization_Code,                          Ood.Organization_Name                     FROM Org_Organization_Definitions Ood                    WHERE Ood.Organization_Id = Msi.Organization_Id)      FROM Mtl_System_Items_b Msi;END;