ORA-00996

Error: ORA-00996: the concatenate operator is ||, not |

Causa: A single bar (|) was interpreted as an attempt to specify concatenation, but the concatenation operator is a double bar (||).

Acción: Enter a double bar (||) for concatenation or remove the single bar (|) if concatenation was not intended.