Cursor variables as parameters, PL-SQL Programming

Cursor Variables As Parameters

You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CURSOR type EmpCurTyp, and then the cursor variable is declare of that type as the proper parameter of a procedure:

DECLARE

TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE;

PROCEDURE open_emp_cv (emp_cv IN OUT EmpCurTyp) IS...

Posted Date: 10/4/2012 4:01:15 AM | Location : United States







Related Discussions:- Cursor variables as parameters, Assignment Help, Ask Question on Cursor variables as parameters, Get Answer, Expert's Help, Cursor variables as parameters Discussions

Write discussion on Cursor variables as parameters
Your posts are moderated
Related Questions
Using DELETE This process has three forms. The DELETE removes all elements from the collection. DELETE(n) removes the nth element from the nested table. When n is null, then D

Object Type: The object type is a user-defined composite datatype which encapsulates a data structure along with the functions and procedures required to manipulate the data

When Are Constraints Checked Under the model constraints are conceptually checked at all statement boundaries (and only at statement boundaries). By default the same is true

Parameter Modes: You do not require to specify a parameter mode for the input bind arguments (those used, for illustration, in the WHERE clause) as the mode defaults to IN. Th

Expression: This is a randomly complex combination of constants, variables, literals, operators, & function calls. The simplest expression consists of a single variable. If th

Declaring Objects: You can use the object types wherever built-in types like CHAR or NUMBER can be used. In the block below, you can declare object r of type Rational. Then, yo

Updating Variables For assignment, SQL uses the key word SET, as in SET X = X + 1 (read as "set X equal to X+1") rather than X: = X + 1 as found in many computer languages.

What are 3 good practices of modeling and/or implementing data warehouses?

Table Literals - SQL One might expect SQL to support table literals in the manner illustrated in Example 2.2, but in fact that is not a legal SQL expression. Example: Not a

Special cases of projection This section describes the identity projection, r {ALL BUT}, and the projection on no attributes, r { }, which yields TABLE_DUM when r is empty, ot