Where do you use parametrized cursor in oracle apps? Explain with real-time example?

Questions by nettyamraghu

Showing Answers 1 - 6 of 6 Answers

trraka

  • Jan 23rd, 2008
 

Parametrized Cursors are frequently used when picking the data from master -detail tables .(Generally in interfaces) Or the same table with header as well as line information

cursor c1 is select a from  dummy1;

cursor c2(v_variable number) is
select b from dummy2 where
a=v_variable

I hope it is clear....

  Was this answer useful?  Yes

aksesa

  • Apr 5th, 2010
 

Normally when we want to process the bulk records that time we use the parameterized cursor.

Eg: If we want to extract certain PO details every day for DATA WAREHOUSE extract then we have to use the parameterized Cursor. In cursor parameter we can pass status of PO, Extract Date etc.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions