# ORA-01722: invalid number

**Code:** `ORA-01722` · **Category:** SQL · **Seen on:** SQL

Oracle tried to convert a string to a number and failed.

## Meaning

Implicit conversions from comparing VARCHAR2 with numbers, or NLS decimal settings (comma vs dot).

## Common causes

- Comparing varchar columns to numeric literals
- Non-numeric data in a column treated as numeric
- NLS_NUMERIC_CHARACTERS mismatch

## Quick fix

1. Compare with string literals or convert explicitly
2. Use VALIDATE_CONVERSION/TO_NUMBER … DEFAULT NULL ON CONVERSION ERROR (12.2+)

## Detailed fix by platform

### SQL

1. `SELECT TO_NUMBER(code DEFAULT NULL ON CONVERSION ERROR) FROM items;`

## How to diagnose

1. **Expression** — Where is the implicit conversion?
2. **Recent change** — Did it start after a deploy, upgrade, or configuration change? Compare with the last working version.

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/sql/ora-01722-invalid-number)
