how can we return morethan one parameters in procedure?

Question Posted / chandrasekhar.bs

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

More Oracle Apps Technical Interview Questions

what is the database size you used?

in which tables the transaction details stored? at least two.

What are file in oracle.

What do you understand by soa and what are the benefits of using this architecture?

about TCA architecture

what is meant by boilerplates?

what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions

can we use anchor propery in XML reports?if yes?explain?

What is a flexfield? List out its types.

how to customize the report,please tell me customization steps

what are centralized and decentralized level of control of item attributes?

what is item status? name the related table.

For more Oracle Apps Technical Interview Questions Click Here