in procedure how to return a value

Answers were Sorted based on User's Feedback



in procedure how to return a value..

Answer / amit

In a procedure, we can return a value using OUT PARAMETER
or EVEN USING IN OUT PARAMETER.

For Eg:

CREATE OR REPLACE PROCEDURE add_num(a IN NUMBER, b IN OUT
NUMBER) IS
BEGIN
b:= a + b;
END add_num;

The IN OUT / OUT parameters can be modified within PLSQL
block and the updated values of this parameter can be
refered using a actual paramter once the execution of this
procedure is completed.

Is This Answer Correct ?    8 Yes 0 No

in procedure how to return a value..

Answer / ravindra babu kamma

using out parameter

Is This Answer Correct ?    3 Yes 2 No

in procedure how to return a value..

Answer / veerabhargav reddy

In procedure we can return value using Out Parameter,

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Oracle Apps Technical Interview Questions

can we use anchor propery in XML reports?if yes?explain?

2 Answers   Oracle,


What is oracle soa suite?

0 Answers  


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

0 Answers  


what is the back ground program run while transferring data from OM to AR?

4 Answers   Qwest,


hi all.i am in need of some sample codes for oracle apps manufacturing interfaces.If any of u have,plz send it to me . Thank you.

1 Answers   BirlaSoft,






In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,


WHAT IS USE OF APPS API?

3 Answers  


How to create a link between One dependent value set to another Dependent value set

5 Answers   Indorama, ManSoft System, Syntel, TE Data,


What are do's and dont's of Interface?

0 Answers  


i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,


AOL?

4 Answers  


I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????

4 Answers   Satyam,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)