Oracle PL-SQL Interview Question:

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification?

Submitted by: Administrator

A cursor declared in a package specification is global and can be accessed by other procedures or procedures in a package.
A cursor declared in a procedure is local to the procedure that can not be accessed by other procedures.
Submitted by: Administrator