Oracle Error Message
PLS-00178: a static character expression must be used
Reason for the Error
The expression contained a syntax or semantic error, or it did not have a character type or its evaluation raised an exception.
Solution
Write correct static character expression.