Check out the section on using collections here http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/05_colls.htm
If you have anything that you specifically don't get after that, then come back and give us a poke but I think the link should answer your question pretty effectively Rob On Nov 20, 11:21 am, pbbeginner <[EMAIL PROTECTED]> wrote: > Most procedures that i've worked with in the past just has variable > type of parameters but this one is using a table. I guess that is a > temp table? > > Here is an example of the procedure: > > PROCEDUE receive_students (as_studenttable IN Student_Table) IS > > Variables Declared > > Begin > For i in 1..as_studenttable.count Loop > > Begin. > > How do I test this or search for it on google...I have access to sql > plus? > > Thanks for the help --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---