can we pass two out parameters at a time in function?please
answer to my question

Answers were Sorted based on User's Feedback



can we pass two out parameters at a time in function?please answer to my question..

Answer / abhisudipta

No, naturally we can't pass the two out parameter in a
function , because function will return only one value with
only specified data type in return statement. But we can do
with using the ref-cursor if I hold values through runtime
then we can return so many values.

Is This Answer Correct ?    6 Yes 1 No

can we pass two out parameters at a time in function?please answer to my question..

Answer / nathan

Yes,We can pass two out parameters in a function, but there
should at least one in parameter, because using the in the
function will do something.It'll not throw any errors.

Is This Answer Correct ?    0 Yes 0 No

can we pass two out parameters at a time in function?please answer to my question..

Answer / mohit

Yes, we can pass two OUT parameters in a functions. Also
you can use there two OUT parameters in calling function as
well.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle General Interview Questions

what is the exact definition for pointer?

7 Answers   Wipro,


what is RAID technology?which is better RAID 0+1 OR RAID 5?

2 Answers   CSC,


It's Urgent? How to IMPORT .xls & .txt file into ORACLE?

5 Answers  


How to use in conditions in oracle?

0 Answers  


What are the differences between char and varchar2 in oracle?

0 Answers  






What is materialized view in Oracle?

0 Answers   MCN Solutions,


What is a system tablespace?

0 Answers  


Can sub procedure/function be called recursively?

0 Answers  


How to resolve name conflicts between variables and columns?

0 Answers  


Explain an exception and its types?

0 Answers  


What are the Referential actions supported by FOREIGN KEY integrity constraint ?

1 Answers  


How can I create database in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)