Home » Auto Computing Reviews » Ora-24381 Finding Root Cause

Ora-24381 Finding Root Cause

Marcus Vance • • 2 min read
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

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.

2

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Marcus Vance
Author

Marcus Vance

Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.