hi amit..newbie oracle help me please!!

[ramorac]

Hi..

My requirement is to populate the fields in the front end screen(application screen) points weightage and rating when a particular answer is chosen from the combobox in front end.
For illustration:
I m using a cursor to get the fields from a table say.,Points and Weightage which in turn is used in a formula to calculate Rating.I used a function for this Rating.With cursor i fetch the point and weightage.. and a function for the Rating. But how do i get also the rating in the front end..i mean to bring the rating.Can i do this in cursor again.Pleas help.

[amitpatel66]

Hi..

My requirement is to populate the fields in the front end screen(application screen) points weightage and rating when a particular answer is chosen from the combobox in front end.
For illustration:
I m using a cursor to get the fields from a table say.,Points and Weightage which in turn is used in a formula to calculate Rating.I used a function for this Rating.With cursor i fetch the point and weightage.. and a function for the Rating. But how do i get also the rating in the front end..i mean to bring the rating.Can i do this in cursor again.Pleas help.

What is your front end by the way? And you have already implemented a function that calculates the rating and return the rating value back. So form your front end application, on buttion click you can call this function and assign it to some display fied that displays the value.