Skip to Main Content
Oracle PL/SQL Programming: A Developer's Workbook
book

Oracle PL/SQL Programming: A Developer's Workbook

by Steven Feuerstein, Andrew Odewahn
May 2000
Intermediate to advanced content levelIntermediate to advanced
594 pages
11h 32m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL Programming: A Developer's Workbook

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:

  1. You cannot pass a cursor variable through the parameter list of a remote procedure call (RPC). The variable points to a result set in the current database instance.

  2. You cannot use comparison operators to test two or more different cursor variables for equality, inequality, or nullity (IS NULL or IS NOT NULL).

  3. You cannot use a REF CURSOR type to specify the element type of a collection (error PLS-00990). As a consequence, a cursor variable may not be an element in a nested table, index-by table, or VARRAY.

  4. Even through the two different REF CURSOR types have the same RETURN clause, they are considered different types; you cannot, therefore, assign tmp_cv to emp_cv.

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:

 /* Filename on web page: cah.pkg */ CREATE OR REPLACE PACKAGE cah AS TYPE tainted_person IS REF CURSOR; PROCEDURE identify_person ( ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 9781449324070Supplemental ContentErrata Page