Oracle & .NET: Resolve – Exception calling “Fill” with “1” argument(s): ‘count’ must be non-negative.

This is one of those obscure errors that has no answer on the Web. I ran into this error trying to migrate an Oracle table to SQL Server (one of many). The issue seemed to be only with certain rows of this table as it migrated majority of the data without issues. Below is the … Continue reading Oracle & .NET: Resolve – Exception calling “Fill” with “1” argument(s): ‘count’ must be non-negative.

Advertisements

Oracle – Interval Datatype – Extracting Components (Years/Months/Days/Hours/Minutues/Seconds)- Usage Example Reference

If you have not checked my quick intro to the Interval datatype here, please do so before reading on. Now, that we know the “interval” data type, let us see how we can extract out the individual components within it for both the “DAY TO SECOND” and “YEAR TO MONTH” variations. The following example should … Continue reading Oracle – Interval Datatype – Extracting Components (Years/Months/Days/Hours/Minutues/Seconds)- Usage Example Reference

Oracle – Enumerate tnsnames.ora Entries Without Parsing

Parsing tnsnames.ora using PowerShell I published a post on how to enumerate tnsnames.ora entries using PowerShell. Although it may work, that is not the correct way to do this. This is a re-post of my tip on CodeProject. This should be easy enough to convert to PowerShell. However, if your tnsnames.ora is not the one that … Continue reading Oracle – Enumerate tnsnames.ora Entries Without Parsing

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”

Parsing Out Oracle TNSNames.ora Using PowerShell

TNSNames.ora If you work with Oracle, you are no stranger to TNSNames.ora whether or not you currently use it. In short, it is a local/network configuration file used by the Oracle client(s) to point and connect to Oracle databases. One could use other methods like LDAP or EZConnect as alternatives but TNSNames.ora is more common … Continue reading Parsing Out Oracle TNSNames.ora Using PowerShell