Re: using PL/SQL tables to store values

Mark C. Stock wrote:
> <happyardy_at_gmail.com> wrote in message
> news:1154797266.923101.275840_at_i42g2000cwa.googlegroups.com...
> : Hello All,
> : I am trying to write an application for Student Transfer Articulation.
> : I have 3 fields(1st one is a drop down menu for "Subject", 2nd one is a
> : text field for "Course Number" and 3rd one is a drop down menu for
> : "Year") to make up a row on my form. I am allowing a maximum of 10 rows
> : on the form.
> : I am planning to use PL/SQL tables to store the values that are entered
> : on the form.
> : Can someone let me know how I can do this ? I mean, how do I actually
> : get the values from the form into the PL/SQL table and then retrieve
> : those ? I have the front end ready and want to know how things would
> : happen once I click on the "Submit Query" button.
> : I am new to PL/SQL etc and hence the question.
> : - Ardy
> :
>
> typically PL/SQL tables are temporary in-memory storage used in database
> packages or in Oracle's Forms and Reports developer tools...
>
> what development tools are you using?

> why do you want to use PL/SQL tables? where would the tables reside?
>
> ++ mcs

Thanks for your reply.
I am using Oracle SQL Developer to code(if that is what you meant by development tools).
I have been told to use PL/SQL tables since it would also be a good exercise for future development here. At this point I am really not that knowledgable to make an educated choice about whether PL/SQL tables are the best way to go for my application. thanks

• Ardy I have been told to use PL/SQL tables