Hi,1. Iam looking for sample program for ref cursor. ref cursor can be associated with many select statements and we can use the ref cursor to return the multiple value from the procedure or function. how to use the ref cursor in a program to associate with many select statements.2. we can't use the %rowtype attribut to return the multiple from the procedure or function instead of ref cursor. if we...

krishnamohan_geek

 Profile Answers by krishnamohan_geek Questions by krishnamohan_geek

• Mar 25th, 2007

Hi,Let me answer your second questin first. Why ref cursor instead of %ROWTYPE.%ROWTYPE is used for fetches record/row of a single table.OR in case of columns of different tables then you have to crea...

Answer Question  Select Best Answer