Expert
Q: | |
12-17. | When you declare a cursor variable as the formal parameter of a subprogram that opens the cursor variable, you must specify the parameter to be of mode OUT or IN OUT. That way, the subprogram can pass an open cursor back to the caller. |
Q: | |
12-18. | Problems are:
|
Q: | |
12-19. | The declaration in (a) defines a cursor variable in SQL*Plus of type REF CURSOR (weak). The following is an example of declaring and using such a variable: SQL> VARIABLE bysal REFCURSOR SQL> exec :bysal := empinfo.open (empinfo.bysal) PL/SQL procedure successfully completed. SQL> |
Q: | |
12-20. | Here is one possible implementation:
|