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...


how can we return morethan one parameters in procedure?

Answers were Sorted based on User's Feedback



how can we return morethan one parameters in procedure?..

Answer / nithya

using 'OUT' parameter u can return any no. of values in
procedure.

Is This Answer Correct ?    3 Yes 2 No

how can we return morethan one parameters in procedure?..

Answer / uday

using refcursor

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Apps Technical Interview Questions

How to migrate .rdf file from dev instance to test instance?

3 Answers   Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,


What is INBOUND and OUT BOUND? (Different types of interfaces)

17 Answers   Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,


If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

3 Answers   Accenture,


1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

2 Answers   Cap Gemini,


What is a value set? List its various types.

0 Answers  


what is the difference between character mode,bitmap mode

2 Answers   IBM, Sierra Atlantica,


Tell me some errors names and number what u got while developing the reports?

1 Answers  


what are version control tools used in oracle apps?

1 Answers   Cap Gemini, Sony,


What is the link between AP and GL in oracle apps R/12?

4 Answers   Bosch, Collabera, Synechron,


What r the validation types?

3 Answers  


In a Standard form a DFF is disable?How we can Enable it?

5 Answers   Caritor, TCS,


What repots or concurrent program run to transfer data from Inventory to GL.

5 Answers   IBM, iGate,


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)