Oracle Package Usage

Question

I have been tasked with converting some old PERL code to a windows service utilizing C# and .NET. However, there are some very well done packages in our Oracle database which I would like to continue using. How does one go about calling one of these packages? The first ones I'm dealing with do not return any rows, but do return output parameters indicating number of rows updated and success status.

Answer 1

Create command: OracleCommand command=new OracleCommand(); command.Connection=conn; command.CommandType=CommandType.StoredProcedure; command.CommandText=packageName+"."+procedureName; Then: then add parameters for this command command.parameters.add(new oracleparameter.....) ... .. After that: Set values to the parameters... And : execute command.