Question on invoking PL/SQL functions within a form
630331Nov 10 2009 — edited Nov 12 2009Hi...
I am a beginner in Forms and I am building a totally custom form wherein a user can enter the item they want and qty and other features such as colors and based on that system would give a low and high price and user chooses a price anywhere in between low and high price.
I have written function to calculate low and high cost with what users choose as parameters such as material, color etc.
Low Price, High price and price the user puts in are columns in same table.
I tried populating the low price by calling the low price function in property pallete under the formula. This works but issue is till user chooses all the required fields in run time, the system displays FORMAULA_CALCULATION trigger.
Is my approach correct or is there a more efficient way of accomplishing this?
The low price and high price should always get populated from functions and user should not be able to change them and price the users chooses should be between the 2.