Cascading LOV - Invalid number while updating record - Oracle Apex

0
votes

I have a select list based on other select list. It works fine on the create screen but gives 'Invalid number' error in update screen.

SQL query: 

select description, account_id
from t_account
where chart_id = :P15_chart_name

Please help me out!

1
oracleoracle-apex

1 Answers

0
votes

You are trying to convert a string into a number, and that failed.

As Select List item has 2 values: 1st being display and the 2nd return value, it is the 2nd value that causes problems - account_id in your case.

For example, it contains value A while column that is supposed to accept this value is declared as NUMBER. Oracle can't convert A into a number and raises an error.

What to do?

  • make sure that Select List item LoV query returns only numbers, or
  • modify column's datatype to varchar2

If that's not it, then :P15_CHART_NAME item and chart_id table column differ in datatypes; a simple option is to fix page item's datatype.