I have written a procedure in which the cursor is fetching 2 lakh records. I would like to pass on these 2 lakh records as an in paramter to the other procedure. How can we achieve this logic?

  • Interview Candidate
  • 4
  • 2472

Showing Answers 1 - 4 of 4 Answers

Shailen

  • Aug 2nd, 2006
 

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

  Was this answer useful?  Yes

Rama Krishna.Yerra

  • Aug 9th, 2006
 

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

  Was this answer useful?  Yes

prasanna

  • Nov 14th, 2006
 

hi friend

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

  Was this answer useful?  Yes

prakash

  • Nov 15th, 2006
 

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.

  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