Pass a row record to Oracle procedure using System.Data.OracleClient

Question

I would like to pass 51 plus parameter to an oracle stored procedure, i would like to pass them as a collection/array or custom object. I know its possible using assiative arrays using ODP driver but I am using OracleClient. How will I be able to achieve this, would not like to pass 50 plus fields as individual parameters.

Answer 1

Pass a record as a string with values separated by a pipe (|) or any character of your choice. On database end split the passed string values.

Not the optimal solution but it works.