ORA-30000: missing either trim specification or char expression in TRIM
Cause: Since FROM is specified in TRIM function, either trim specification (TRAILING, HEADING, BOTH) or trim character or both must be specified
Action: Add either trim specification (TRAILING, HEADING, BOTH) or trim character or both
https://support.oracle.com/
http://www.oracle.com/