Parameter Modes 

To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, avoid using the OUT and IN OUT modes with functions. The aim of a function is to take zero or more arguments and return a single value. To have a return function, multiple values is a bad programming practice. The functions should also be free from the side effects that change the values of variables not local to the subprogram. 

Posted Date: 10/5/2012 5:30:45 AM | Location : United States

Ask an Expert

Related Discussions:- Parameter modes, Assignment Help, Ask Question on Parameter modes, Get Answer, Expert's Help, Parameter modes Discussions

Write discussion on Parameter modes
Your posts are moderated

Write your message here..

Related Questions

Data type conversion, Datatype Conversion At times it is necessary to c... Datatype Conversion At times it is necessary to convert a value from one datatype to another. For e.g. if you want to inspect a rowid, you should convert it to a character stri

Components of an object type - attributes in pl/sql, Attributes: Just ... Attributes: Just similar to variable, an attribute is declared with a name and datatype. The name should be exclusive within the object type. The datatype can be any Oracle ty

Develop data business intelligence project, Develop Data Business Intellige... Develop Data Business Intelligence Project Project Description: We are linking our Microsoft SQL Database to GoodData Business Intelligence. We are seeking somebody who has e

CURSOR, #quesWrite a cursor to open an employee database and fetch the empl... #quesWrite a cursor to open an employee database and fetch the employee record whose age is greater than 45.tion..

Using bulk collect clause- bulk bind performance improvement, Using the BUL... Using the BULK COLLECT Clause The keywords BULK COLLECT specify the SQL engine to bulk-bind output collections before returning them to the PL/SQL engine. You can use these ke

Update the Status of an Ordere, Create a procedure named STATUS_SHIP_SP tha... Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTAT

If statement - syntax, IF Statement The IF statement executes a series ... IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

Commit statement in pl sql, COMMIT Statement The COMMIT statement expli... COMMIT Statement The COMMIT statement explicitly makes everlasting changes to the database during the present transaction. The Changes made to the database are not considered e

Program, heap sort program in pl/sql heap sort program in pl/sql

Cause of indeterminacy in sql, Cause of Indeterminacy in SQL One root ... Cause of Indeterminacy in SQL One root cause of indeterminacy in SQL lies in its implementation of comparison for equality. For certain system-defined types it is possible for