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

how many sections are there in report?

1 Answers  


After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?

3 Answers   IBM,


Form development process?

1 Answers  


How can a process be deployed in soa?

0 Answers  


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

0 Answers  


suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?

3 Answers   Oracle,


Can we run a package with out specification?If yes how?

4 Answers  


In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,


What is set function in sql .E.g.What is difference between union and union all

2 Answers   IBM, TCS,


Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?

4 Answers   Zensar,


How to move the one file from one instance to another instance? And your scripts also?

0 Answers  


What is the autonomous transaction?give me example?

2 Answers   Cap Gemini,


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)