Oracle Solution for Error ora-08412

ORA-08412: error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message

What triggered the Error:

The WMSGBSIZ is the maximun size for warning message block, it is recommanded to be 1024 bytes to 8 kbytes.

What should we do to fix it:

Defined WMSGBLK of size between 1k to 8k bytes and update the WMSGBSIZ to the sizeof(WMSGBLK).