Pass PL/SQL associative array to Oracle stored procedure from C#

The ArrayBind feature of ODP.NET comes allows passing arrays to a stored procedure. Since all parameters should be arrays of equal length, it may not be the right choice if not all parameters are arrays. Say, we want to call a procedure that takes a user name and an array of role names …

Read

OracleDataReader GetOrDefault() extension method

The various GetXXX methods of the OracleDataReader class take a zero-based column index instead of the column name. Referring columns by index instead of name leads to hard to understand code. Additionally, the code may be susceptible to errors if the column order is modified. …

Read

ODP.NET CreateCommand() extension method

The amount of code to prepare an OracleCommand object to call a stored procedure is quite boring. I created a simple extension method on the OracleConnection class that makes things easiy. …

Read