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 can we return morethan one parameters in procedure?

2 Answers  


What are triggers?

3 Answers  


what is the difference between procedure and function

3 Answers   Wipro,


The Task is that to register a Form into Oracle Apps on a particular responsiblity. - First i moved the FMX & FMB file into the custom_top through FTP - Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly.. - When i get into the particular responsiblity i can see the Form name getting listed. But when i click that to open..... i cant able to see the form. I need any one your help in advicing me...what would be the problem.

7 Answers   SGS,


WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers  






In one flat file i got headers and lines data how you can write control file now ?

1 Answers   KPMG,


What are Mandatory triggers to write in the block, which is created on view?

5 Answers   Oracle,


How will u register concurrent request ?

1 Answers   Convergys,


for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake

3 Answers  


IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?

7 Answers   Accenture,


What is the autonomous transaction?give me example?

2 Answers   Cap Gemini,


How You Will display the key flexifields in your report

3 Answers   TCS,


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)