How to Resolve – “ORA-24381: error(s) in array DML”

"Oops! Something went wrong" seems to be the fashionable thing to do when throwing errors these days. Not surprisingly, when issuing a query from PowerShell against Oracle, it kept producing this error at random ORA-24381: error(s) in array DML The error did not always happen. It only happened once in a while and it was … Continue reading How to Resolve – “ORA-24381: error(s) in array DML”

Oracle nasty dates finder for the .Net folks – Fix “Year, Month, and Day parameters describe an un-representable DateTime.”

If you are querying Oracle from .Net and you get this error: Exception calling "Fill" with "1" argument(s): "Year, Month, and Day parameters describe an un-representable DateTime." ---> System.ArgumentOutOfRangeException: Year, Month, and Day parameters describe an un-representable DateTime. It is most likely because of DateTime column(s) having a value of 00000000 00:00:00 or because the … Continue reading Oracle nasty dates finder for the .Net folks – Fix “Year, Month, and Day parameters describe an un-representable DateTime.”