ORA-01481: invalid number format model
Oracle PL/SQL error message: ORA-01481: invalid number format model.
Cause:
An invalid format parameter was used with the TO_CHAR or TO_NUMBER function.
Solution:
Correct the syntax, then retry the operation.
Example 1:
SELECT TO_NUMBER(SYSDATE,'HH24') FROM DUAL;
Output:
ORA-01481: invalid number format model
Correct:
SELECT TO_CHAR(SYSDATE,'HH24') FROM DUAL;
Output:
10
