Answer Posted / suresh
Ref cursor is a dynamic cursor. it will open more then one active set area.we two types of ref cursors.
1.strong ref cursor-with return type.
2.weak ref cursor- with out return type.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
In hierarchical structure of a database? we have write query from where we should start?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
Tell me how to debug the report?
Can you differentiate between mediator and osb?
Suppose 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 lessthen it must shows some error how we will make?
What are the different components you should consider while defining a responsibility in oracle apps?
what is pay run id ?
How is choreography different from orchestration?
testing tools?
What are the benefits of using soa architecture?
Which oracle apps version you are very confident in?
How do you register report in oracle apps?
Is soa a part of oracle fusion middleware?