Interested to Buy Any Domain ? << Click Here >> for more details...
can we pass two out parameters at a time in function?please
answer to my question
- 3 Answers
- 6229 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Point the difference between translate and replace?
How to use fetch statement in a loop?
What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
Can group functions be mixed with non-group selection fields?
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
when do u go for hash partitioning?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What are a cluster and non-cluster index?
what is exact difference between drop and truncate table.
how to get the index id?
How can we find out the duplicate values in an oracle table?
how to hide the stored procedure inside a package
Oracle General 
