Oracle SQL Question:
Download Job Interview Questions and Answers PDF
How to pass cursor variables in PL/SQL 2.2?
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 Question | Next Question |
| Explain me can the default values be assigned to actual parameters? | Explain What is difference between SUBSTR and INSTR? |