InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How You Were Passing 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. 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. |
|