can we pass two out parameters at a time in function?please
answer to my question
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 |
Describe an oracle table?
How to create lov dynamically at runtime & attach to text field?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
What is PL/SQL ?
What are the execution control statements in oracle?
How to store only time; not date and time?
Is there any function in oracle similar like group_concat of mysql?
How to define a record variable to store a table row?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How many anonymous blocks can be defined?
What is the data pump import utility?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)