Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What do you understand by soa and what are the benefits of using this architecture?

0 Answers  


HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?

2 Answers   TCS,


What do you understand by a set of books?

0 Answers  


wht is format triger?

4 Answers  


where is setup of business group done?

2 Answers   TCS,


why r u move in the cus_top only why not move another top

4 Answers  


what is pl/sql table and pl/sql records? what is the use of that?

3 Answers   Intelligroup,


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,


what is flexfield qualifier?

3 Answers  


how can develope the po variance and po summary report? with tables mandatory columns and query please?

0 Answers  


mention the interface tables for item open interface and open transaction interface and also their respective production tables.

1 Answers   Scan Steel,


Is that Possible To create package without Specification , If Yes Give any Examples

2 Answers   PWC,


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)