Cursors & Packages
From: Biju Kurian <kevin96_at_rocketmail.com>
Date: Wed, 9 Dec 1998 21:50:26 -0600
Message-ID: <74ng3f$qqa$1_at_ionews.ionet.net>
Hi,
Is there a book which talks in detail about the uses of cursors inside packages? I am having trouble when defining the return clause for my cursors. I cannot use %ROWTYPE since I have data coming from multiple tables. So I created programmer-defined record types. Still I am having trouble when calling the cursors from my procedures. The book I am following, Oracle PL/SQL programming by Steven Feurstein, talks only about cursors(inside package) with only one table. I am defining cursors inside packages because I need to use the same cursors mutliple times and I can acheive the same by using the dot notation(package.cursor).
Date: Wed, 9 Dec 1998 21:50:26 -0600
Message-ID: <74ng3f$qqa$1_at_ionews.ionet.net>
Hi,
Is there a book which talks in detail about the uses of cursors inside packages? I am having trouble when defining the return clause for my cursors. I cannot use %ROWTYPE since I have data coming from multiple tables. So I created programmer-defined record types. Still I am having trouble when calling the cursors from my procedures. The book I am following, Oracle PL/SQL programming by Steven Feurstein, talks only about cursors(inside package) with only one table. I am defining cursors inside packages because I need to use the same cursors mutliple times and I can acheive the same by using the dot notation(package.cursor).
Please give me some ideas. Thanking you all in advance.
Biju Kurian
bijuk_at_bigfoot.com
Received on Thu Dec 10 1998 - 04:50:26 CET