Re: using PL/SQL tables to store values

<happyardy_at_gmail.com> wrote in message
news:1154820165.589749.30340_at_m79g2000cwm.googlegroups.com...
>
>> :
>> : 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
>> :
>>
>> actually, i meant, what is your user interface? what kind of 'form' are
>> you
>> referring to?
>>
>> and once you store the data in the PL/SQL tables (quite ananlogous to
>> arrays, as Hans pointed out) how will the data in the arrays be used?
>> will
>> it be ready by another process or does it need to be stored in the
>> database?
>>
>> ++ mcs
>
> I am using Oracle PL/SQL for Web. So basically creating web pages using
> htp procedures. I mentioned the word forms because I am using a lot of
> htp.form<aaaa) etc.
>
> After the user inputs values for Subject, Course number and year.
> E.g(for say 3 subjects at a time)
>
> English 101 1999
> French 235 1997
> Math 450 2000
>
> (these are the course that he/she has taken at their university and
> want to know if these can be transferred to my univ. here..that is the
> application i am working on)
>
> and clicks on "Submit" button, I need to get these values from the
> webpage and then run queries again the database tables that I have
> using these values.
>
> After the processing is done, the user(prospective student) would see
> on the screen the equivalent courses at my university for his/her
> entered courses and would know what courses of his/her can be
> transferred here.
>
> thanks & regards
> - Ardy
>

Have you looked at using App Express, as apposed to htp. form and such? It is a great tool for what you are looking to do and its FREE!! Received on Sat Aug 05 2006 - 22:01:36 CDT