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

How do you register report in oracle apps?

0 Answers  


do i need to declare bind parameter before using in the query?

2 Answers   Satyam,


What is function?

2 Answers   Motorola,


what is the defference between credit memo and debit memo

2 Answers  


Presently u are working in which version?

4 Answers   Accenture,






What is workflow?Explain with a example?

2 Answers   Oracle,


While running the concurrent program we will get the status, we have to change the status. How it will be done.

2 Answers   Zensar,


What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,


we have select statement in that two exceptions that returns no value. In that which exception will raise?

2 Answers  


We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,


what type of testing u r doing?

2 Answers   Convergys,


what are the tables of auto invoice.

2 Answers  


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)