What are the modes of parameters that can be passed to a procedure ?

What are the modes of parameters that can be passed to a procedure ?
by

1 Answer

Answer :

IN,OUT,IN-OUT parameters.
by

Related questions

What are different modes of parameters used in functions and procedures?

Description : What are different modes of parameters used in functions and procedures?

Last Answer : IN -OUT -INOUT

What are the different modes of mounting a Database with the Parallel Server ?

Description : What are the different modes of mounting a Database with the Parallel Server ?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.

What are the minimum parameters should exist in the parameter file (init.ora) ?

Description : What are the minimum parameters should exist in the parameter file (init.ora) ?

Last Answer : DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control ... an ORACLE instance acquires at database startup. Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS.

Can the default values be assigned to actual parameters?

Description : Can the default values be assigned to actual parameters?

Last Answer : Yes

Where can one get a list of all hidden Oracle parameters? (for DBA

Description : Where can one get a list of all hidden Oracle parameters? (for DBA

Last Answer : Oracle initialization or INIT.ORA parameters with an underscore in front are hidden or unsupported parameters. One can get a list of all hidden parameters by executing this query: select * from SYS.X$KSPPI ... 1,1)='_' order by a.ksppinm; Remember: Thou shall not play with undocumented parameters!

What are the two ways by which data can be generated for a parameters list of values?

Description : What are the two ways by which data can be generated for a parameters list of values?

Last Answer : 1. Using static values. 2. Writing select statement.

What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Description : What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Last Answer : LOVs can be attached to parameters in the reports 2.5 parameter form.

Can you pass data parameters to forms?

Description : Can you pass data parameters to forms?

Last Answer : No

Do user parameters appear in the data modal editor in 2.5?

Description : Do user parameters appear in the data modal editor in 2.5?

Last Answer : No

What are parameters?

Description : What are parameters?

Last Answer : Parameters provide a simple mechanism for defining and setting the valuesof inputs that are required by a form at startup. Form parameters are variables of type char,number,date that you define at design time.

What are the Built-ins used for sending Parameters to forms?

Description : What are the Built-ins used for sending Parameters to forms?

Last Answer : You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.

What are the various types of parameter modes in a procedure ?

Description : What are the various types of parameter modes in a procedure ?

Last Answer : IN, OUT AND INOUT.

What are the two parts of a procedure ?

Description : What are the two parts of a procedure ?

Last Answer : Procedure Specification and Procedure Body.

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Last Answer : Break. SYSTEM VARIABLES

What package procedure is used for calling another form ?

Description : What package procedure is used for calling another form ?

Last Answer : Call (E.g. Call(formname)

What ERASE package procedure does ?

Description : What ERASE package procedure does ?

Last Answer : Erase removes an indicated global variable.

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Description : Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Last Answer : A function and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a single task. While a procedure does not have to return any ... functions and procedures that are grouped together based on their commonality to a business function or application.

What are Procedure,functions and Packages

Description : What are Procedure,functions and Packages

Last Answer : Procedures and functions consist of set of PL/SQL statements that are grouped together as a unit to solve a specific problem or perform set of related tasks. Procedures do not ... Provide a method of encapsulating and storing related procedures, functions, variables and other Package Contents

Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE

Description : Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE

Last Answer : I) FALSE

What is syntax for dropping a procedure and a function .Are these operations possible?

Description : What is syntax for dropping a procedure and a function .Are these operations possible?

Last Answer : Drop Procedure procedure_name Drop Function function_name

Difference between procedure and function.?

Description : Difference between procedure and function.?

Last Answer : Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.

What is a Procedure ?

Description : What is a Procedure ?

Last Answer : A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks.

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

Description : What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

Last Answer : A cursor declared in a package specification is global and can be accessed by other procedures or procedures in a package. A cursor declared in a procedure is local to the procedure that can not be accessed by other procedures.

What is difference between a PROCEDURE & FUNCTION ?

Description : What is difference between a PROCEDURE & FUNCTION ?

Last Answer : A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or may not return at all.

What is a stored procedure ?

Description : What is a stored procedure ?

Last Answer : A stored procedure is a sequence of statements that perform specific function.

Give the structure of the procedure ?

Description : Give the structure of the procedure ?

Last Answer : PROCEDURE name (parameter list.....) is local variable declarations BEGIN Executable statements. Exception. exception handlers end;

Name the tables where characteristics of Package, procedure and functions are stored ?

Description : Name the tables where characteristics of Package, procedure and functions are stored ?

Last Answer : User_objects, User_Source and User_error.

What are the different types of Package Procedure ?

Description : What are the different types of Package Procedure ?

Last Answer : 1. Restricted package procedure. 2. Unrestricted package procedure.

What is a Package Procedure ?

Description : What is a Package Procedure ?

Last Answer : A Package procedure is built in PL/SQL procedure.

Classify the restricted and unrestricted procedure from the following.

Description : Classify the restricted and unrestricted procedure from the following.

Last Answer : a. Call b. User-Exit c. Call-Query d. Up e. Execute-Query f. Message g. Exit-From h. Post i. Break? a. Call - unrestricted b. User Exit - Unrestricted c. Call_query - Unrestricted ... Query - Restricted f. Message - Restricted g. Exit_form - Restricted h. Post - Restricted i. Break - Unrestricted.

What Enter package procedure does ?

Description : What Enter package procedure does ?

Last Answer : Enter Validate-data in the current validation unit.

What package procedure used for invoke sql *plus from sql *forms ?

Description : What package procedure used for invoke sql *plus from sql *forms ?

Last Answer : Host (E.g. Host (sqlplus))

Can we use a restricted package procedure in ON- VALIDATE-FIELD Trigger ?

Description : Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

Last Answer : No

What the PAUSE package procedure does ?

Description : What the PAUSE package procedure does ?

Last Answer : Pause suspends processing until the operator presses a function key

What is the difference between restricted and unrestricted package procedure ?

Description : What is the difference between restricted and unrestricted package procedure ?

Last Answer : Restricted package procedure that affects the basic functions of SQL * Forms. It cannot used in all triggers except key triggers. Unrestricted package procedure that does not interfere with the basic functions of SQL * Forms it can be used in any triggers.

EXIT_FORM is a restricted package procedure ?a. True b. False

Description : EXIT_FORM is a restricted package procedure ?a. True b. False

Last Answer : True

Where is a procedure return in an external pl/sql library executed at the client or at the server?

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Description : Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Last Answer : False

An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Description : An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Last Answer : True

How can I message to passed to the user from reports?

Description : How can I message to passed to the user from reports?

Last Answer : By using SRW.MESSAGE function. (Continued on next part...)

How can values be passed bet. precompiler exits & Oracle call interface?

Description : How can values be passed bet. precompiler exits & Oracle call interface?

Last Answer : By using the statement EXECIAFGET & EXECIAFPUT.

What does an authorization profile in an AS ABAP based SAP system contains? A. collection of authorizations B. The user menu C. Profile parameters, such as the password expiration time(login/password_expiration_time) D. The collection of the authorizations checks that a user has passed successfully

Description : What does an authorization profile in an AS ABAP based SAP system contains? A. collection of authorizations B. The user menu C. Profile parameters, such as the password ... (login/password_expiration_time) D. The collection of the authorizations checks that a user has passed successfully

Last Answer : A. collection of authorizations

When an array is passed as parameter to a function, which of the following statements is correct ? (A) The function can change values in the original array. (B) In C, parameters are passed by value, the function cannot change the original value in the array. (C) It results in compilation error when the function tries to access the elements in the array. (D) Results in a run time error when the function tries to access the elements in the array.

Description : When an array is passed as parameter to a function, which of the following statements is correct ? (A) The function can change values in the original array. (B) In C, parameters are passed by value, ... . (D) Results in a run time error when the function tries to access the elements in the array.

Last Answer : (A) The function can change values in the original array.

Code of criminal procedure bill having passed by both houses on a) 25 Jan 1974 b) 2002 c) 01 Jan 1973 d) None of these

Description : Code of criminal procedure bill having passed by both houses on a) 25 Jan 1974 b) 2002 c) 01 Jan 1973 d) None of these

Last Answer : a) 25 Jan 1974

What are some great single player games with underrated multi-player modes?

Description : What are some great single player games with underrated multi-player modes?

Last Answer : Injustice 2

What are modes?

Description : What are modes?

Last Answer : answer:Usually a mode is what number occurs the most often. Here is an example: If I ask ten people what their favorite number between one and ten is and I get these replies [1,7,3, ... it probably means that two numbers had equal amounts of replies. And those replies occurred the most frequently.

Can you explain modes to me?

Description : Can you explain modes to me?

Last Answer : I am not sure if you are just learning this in the setting of theory or improvisation. Modes have to do with what your tonic (root) is. For the C major scale C is the root. And when you play the scale it is ... same your chords are different. C major = C,E,G and D minor = D, F A. Does that help?

Is there a hierarchy to the various modes of perceiving beauty?

Description : Is there a hierarchy to the various modes of perceiving beauty?

Last Answer : It's simply the fact that visual beauty is easier to detect than the other forms. It is the most apparent, it is the one that screams out at you at first and can often be so beautiful that the ... how beautiful that truly is, then it may end up being much more important than what is on the surface.

What are the seven modes in music and how do they correlate with the major scale?

Description : What are the seven modes in music and how do they correlate with the major scale?

Last Answer : answer:the major scale is a set of intervals - half and whole steps. it's easy to see on a piano keyboard -- if you don't have one, draw one (a couple octaves). the major scale goes from C ... chords for each mode (links are in the left column): http://gosk.com/scales/major-scale-for-guitar.php

Are there dumbwaiters for sale that have manual and electric modes?

Description : Are there dumbwaiters for sale that have manual and electric modes?

Last Answer : If this is some way to try to bypass shelling out the bucks for an elevator, I’m thinking it is both unsafe and a building code violation.