Cursor Variables in PL/SQL
From: DooHee Kim~ <4658291d_at_rigel.oac.uci.edu>
Date: Mon, 2 Aug 1999 10:53:58 -0700
Message-ID: <Pine.SOL.4.05.9908021052120.6846-100000_at_rigel.oac.uci.edu>
Using cursor variable (TYPE type_name is ref cursor return return type) How can I define a cursor varaible that retrieves two rows from two different table?
I can get it to return %rowtype and %type but am having no luck at making it return two rowtypes from two different tables. Any suggestion?
Thanks Received on Mon Aug 02 1999 - 19:53:58 CEST
Date: Mon, 2 Aug 1999 10:53:58 -0700
Message-ID: <Pine.SOL.4.05.9908021052120.6846-100000_at_rigel.oac.uci.edu>
Using cursor variable (TYPE type_name is ref cursor return return type) How can I define a cursor varaible that retrieves two rows from two different table?
I can get it to return %rowtype and %type but am having no luck at making it return two rowtypes from two different tables. Any suggestion?
Thanks Received on Mon Aug 02 1999 - 19:53:58 CEST