I am facing problem while installing HTML dB.
"ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
It is locked as Bug3999870 & Bug 3954454, Resolution for same is ::
Set NLS_LENGTH_SEMANTICS to BYTE :
1. ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=BYTE SCOPE = SPFILE ;
2. Shutdown the database.
3. Restart the database.
4. Check the value of NLS_LENGTH_SEMANTICS:
show parameter nls_length_semantics
After following above steps, it again gives the same error.
Did anyone had similar experience, please suggest for resolution.