For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Env: Oracle 11g SE on Windows Server. We dropped a number of views in a specific schema: drop view schema_name.view_name; So far, so good. We noticed that the views were dropped in another schema as well. How could this have happened?
Provide more details about the setup of your page. Is the region Interactive grid? Is the drop-down part of the Grid or is it a master item above it? Better would be to post a photo of your page.
Posting a few pics. This is the error after I select a product from the drop down. SetValue Code: DB Table:
I just tried it on my APEX using same method and it worked. I think the scale and precision difference between the two columns is causing the error? Use TO_NUMBER function with ROUND and see what happens. EDIT: I think you are using Format Mask for one column (unit price). Try removing all format masking and see what happens.
Thx for the sanity check! I think what is happening is that the Unit Price's dollar amount is being passed in as a string, e.g. :unit_price = '$475.00'. When I cast it using to_number the calculation works. to_number(:unit_price, '$99999.99') * :quantity; Again, I appreciate the help! Just saw your edit. Yup, that (format mask) was it.