Data Warehousing Community Forum
October 24, 2019, 01:23:22 am

Pages: [1]   Go Down
  Print  
Author Topic: Package Cursor & Procedure Cursor  (Read 3402 times)
unknown
DW Apprentice
**

Reputation: +9/-0
Offline Offline

Posts: 61



View Profile
« on: January 19, 2008, 11:45:07 pm »

Please Explain the differance between package cursor and procedure cursor ?

Is the both are same or ... ??
Logged

Thanks
Unknown Smiley
advertisement
Sipra
Founder
*****

Reputation: +56/-0
Offline Offline

Posts: 354


Am the King...


View Profile WWW
« Reply #1 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
Logged

Pages: [1]   Go Up
  Print  
Jump to: