Oracle Application Express (MOSC)

MOSC Banner

APEX 18.1, Master-detail IG by date column leads to ORA-01843: not a valid month

edited Jul 19, 2018 2:27AM in Oracle Application Express (MOSC) 2 comments

Master detail relationship between two grids by date column leads to ORA-01843: not a valid month error or to ORA-01858: a non-numeric character was found where a numeric was expected

LEVEL9 trace shows that APEX engine tries to bind date column using wrong format mask (YYYYMMDDHH24MISS instead of DD-MM-YYYY HH24:MI:SS)

Rewrite line to: select q.*,count(*) over () "APEX$TOTAL_ROW_COUNT"from(select "PK","TXT"from(SELECT date '2018-01-01' pk, 'Jan 2018' txt FROM dual UNION ALLSELECT date '2018-02-01' pk, 'Feb 2018' txt FROM dual)qwhere "PK"=:apex$1)qSQL Statement prepared: line count=1, first index=1, last index=1, characters=221, found binds=1bind_value p_name=>apex$1,p_data_type=>DATE,p_format_mask=>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center