Loading

Oracle Package Usage

steve.auld

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

goce micevski22y ago
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.