Troubleshoot fix resolve ORA-01412: zero length not allowed for this datatype

Error Description: The length for type 97 is 0

Fix for this error: Specify the correct length.