Data Warehousing Community Forum

Databases => PL/SQL => Topic started by: unknown on January 19, 2008, 11:45:07 pm



Title: Package Cursor & Procedure Cursor
Post by: unknown on January 19, 2008, 11:45:07 pm
Please Explain the differance between package cursor and procedure cursor ?

Is the both are same or ... ??


Title: Re: Package Cursor & Procedure Cursor
Post by: Sipra on April 08, 2008, 02:19:54 pm
Please Explain the differance between package cursor and procedure cursor ?

Actually I do not think there is any difference in the two. The cursor will remain the same. As package is a group of functions/procedures, You can declare cursors in the package specifications {global access} or the package body {local access}. In procedures, cursors are limited to that procedure itself and cannot be accessed outside the procedure.

Hope this helps...!

Regards