ORA-24381 finding root cause

I faced this error Error message: ORA-24381: error(s) in array DML in doing insert operation. There is no exception handling involved in the sql. Can I know now the root cause for this through any view ?

My database is oracle 12c

1 Answer

Check if this is similar to this article

I figured that my problem had to do Oracle’s bad estimation of the string length (that led to the issue).
So, I forced a CAST to limit the string to 30 characters and the issue went away!

SELECT NVL(MAX(USERNAME), CAST('NOT_THERE' AS VARCHAR2(30)) ) as usr1
FROM DBA_USERS
WHERE USERNAME = 'AN_USER_ID'

In your case, the problem might be a similar data length issue and you might be able to resolve it too with a simple cast.