Parameter and keyword description - procedures, PL-SQL Programming

Parameter and Keyword Description:


The user-defined procedure is declared by this construct.


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


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.


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.


The datatype construct is a type specifier.


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


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.


The user-defined datatype is specified by this construct.


This declares the program object


This construct declares the function.


The procedure is declared by this keyword.


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
SQL Cursor   The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t

Question: Consider the following relations (primary keys are underlined): AUTHOR (ANo, aname, address, speciality) PUBLISHER (PNo, pname, Location) BOOK (BNo, Title, ISBN,

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

Oracle 11 G new features associated with this release:- Enhanced ILM  - Information Lifecycle Management (ILM) has been around for the almost 10 years, but Oracle has made

Effects of NULL in Aggregate Operator - SQL Let aggop(x) be an invocation of some aggregate operator aggop in SQL, where x is an expression (usually an open expression) to be

Blocks: The fundamental program unit in the PL/SQL is the block. The PL/SQL block is defined by the keywords BEGIN, DECLARE, EXCEPTION, and END. These keywords partition the b

Using EXCEPTION_INIT To handle unnamed internal exceptions, you should use the OTHERS handler or the pragma EXCEPTION_INIT. The pragma is a compiler directive that can be th

Creating a SQL file 1. Open a new file in Notepad++ and save it to the location c:\mysql\bin, with the name lab8script.sql (the file extension should be .sql ). Add a MySQL co

Bulk Binds advantages In the Embedded Oracle RDBMS, the PL/SQL engines accept any valid PL/SQL subprogram or block. As the figure shows, the PL/SQL engine executes all procedur