Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to declare a cursor

934101Aug 21 2015 — edited Aug 21 2015

Hi All,

I tried below syntax in package specification but it throws error -

Please suggest way so that I can write down cursor in package body instead of making package specification bulky by declaring a whole curosr.

CURSOR cursor_1 IS RETURN cursor_1%rowtype;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2015
Added on Aug 21 2015
7 comments
830 views