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

Oracle Error Message

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

Reason for the Error

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

Solution

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