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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the balancing segments in AR?

2042


pls send me out bound code of supplers,site,bankiformation code pls as soon as

2213


What is instead of trigger in where we will use?

1128


What are file in oracle.

2182


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2072


In sequence i want to 11 and 15th values how we will write?

2025


What do you understand by soa?

1101


In support project one ticket alloted which steps follows manualy tell me ?

2611


please send me forms, xml pulisher questions,answers

2069


is it possible to run the interface without using oracle apps?

1930


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

2572


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

2315


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3007


do you know is it possible to run the interface without using oracle apps?

1068


List the various types of value set.

1023