DEVFYI - Developer Resource - FYI

How you were passing cursor variables in PL/SQL 2.2?

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

542. How you were passing cursor variables in PL/SQL 2.2?

In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2, the only means of passing a cursor variable to a PL/SQL block is via bind variable or a procedure parameter.

(Continued on next question...)

Other Interview Questions