May 2000
Intermediate to advanced
594 pages
11h 32m
English
12-17. | Suppose you define a package with a procedure that opens a cursor variable as shown: CREATE OR REPLACE PACKAGE dizmee
AS
TYPE swallow_florida_cvt IS
REF CURSOR RETURN hickey_grouse%ROWTYPE;
PROCEDURE open_wide (yum_cv swallow_florida_cvt);
END dizmee;
/
CREATE OR REPLACE PACKAGE BODY dizmee
AS
PROCEDURE open_wide (yum_cv swallow_florida_cvt)
IS
BEGIN
OPEN yum_cv FOR SELECT * FROM hickey_grouse;
END open_wide;
END dizmee;
/Why does the package body fail to compile? |
12-18. | None of the following blocks compile. Explain the problems.
|
12-19. | Which of the following declarations allows you to work with REF CURSORs in SQL*Plus?
|
12-20. | The following scenario is used for this question and the next. Suppose you are building a repository of ... |