Parameter and keyword description - procedures, PL-SQL Programming

Parameter and Keyword Description:

procedure_name

The user-defined procedure is declared by this construct.

parameter_name:

This identifies the formal parameter that is a variable declared in the procedure specification and referenced in the procedure body.

IN, OUT, IN OUT:

These parameter modes define the behavior of the formal parameters. An IN parameter pass the values to the subprogram being called. The OUT parameter returns the values to the caller of the subprogram. An IN OUT parameter passes the initial values to the subprogram being called and returns the updated values to the caller.

NOCOPY:

This is a compiler hint but it is not directive, that allows the PL/SQL compiler to pass the OUT and IN OUT parameters by the reference rather than of by value.

Datatype:

The datatype construct is a type specifier.

:= | DEFAULT:

This keyword or operator allows you to initialize the IN parameters to the default values.

Expression:

This is a randomly complex combination of constants, variables, literals, operators, & function calls. The easiest expression consists of a single variable. When the declaration is explained, the value of the expression is assigned to the parameter. The value and the parameter should have the compatible datatypes.

type_definition:

The user-defined datatype is specified by this construct.

item_declaration:

This declares the program object

function_declaration:

This construct declares the function.

procedure_declaration:

The procedure is declared by this keyword.

exception_handler:

This construct relates an exception with a series of statements that is executed when the exception is raised.

Posted Date: 10/8/2012 7:33:00 AM | Location : United States







Related Discussions:- Parameter and keyword description - procedures, Assignment Help, Ask Question on Parameter and keyword description - procedures, Get Answer, Expert's Help, Parameter and keyword description - procedures Discussions

Write discussion on Parameter and keyword description - procedures
Your posts are moderated
Related Questions
Cursor Variables:   To execute the multi-row query, the Oracle opens an unnamed work region that stores the processing information. You can use an explicit cursor that names

Package Specification The package specifications contain the public declarations. The scopes of these declarations are local to your database representation and global to the

Project Description: I have two types of data sources. One that is a list in SharePoint and another that is an access desktop database. The access desktop database is fairly com

ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il

Joining in SQL Joining IS_CALLED and IS_ENROLLED_ON in SQL SELECT * FROM IS_CALLED NATURAL JOIN IS_ENROLLED_ON This is an example of an SQL table expression. I have been

LOB Types The large object (LOB) datatypes like BFILE, BLOB, CLOB, and NCLOB store the blocks of unstructured data (like graphic images, text, video clips, and sound waveforms)

Declaring Cursor Variables Once a REF CURSOR type is define by you, and then you can declare the cursor variables of that type in any PL/SQL block or subprogram. In the exampl

Committing and Rolling Back The COMMIT and ROLLBACK end the active autonomous transaction but do not exit the autonomous routine. As the figure shows, if one transaction ends,

Using SAVEPOINT The SAVEPOINT names and marks the present point in the processing of a transaction. Used with the ROLLBACK TO statement, the savepoints undo parts of a transac

Projection in SQL - correct version Student StudentId is enrolled on some course. SELECT DISTINCT StudentId FROM IS_ENROLLED_ON In more complicated examples it is someti