Oracle SQL Question:

Download Job Interview Questions and Answers PDF

How to pass cursor variables in PL/SQL 2.2?

SQL Oracle Interview Question
SQL Oracle Interview Question

Answer:

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.

Download SQL Oracle Interview Questions And Answers PDF

Previous QuestionNext Question
Explain me can the default values be assigned to actual parameters?Explain What is difference between SUBSTR and INSTR?