I will probably say check your logic -

1. First of all why do you need to process 2 lac records in Cursor. There are round abouts

3. Please specify which you want to send these rows as parameters

Srinivas !!

You Logic is correct You can have wht ever you want.wht we hve to do is...

Create a ref cursor in a package..Then create an Instance of that cursor in PL/SQL block.then pass that Instance of the cursor as a variable to the procedure.. by specifing the variable type as type of that Instance.. Then its work ...

Thanks&Regds

Ramki TCS

hi friend

of course no need of sending 2lakh records but some records whatever i required

Hi

I would suggest not to pass all the records to you next procedure. You should look to redesign your next procedure so that it accepts one record and process it. This way you can iterate thru records in your main process and call the next process wherever required.