'Declaration Public Class OraclePackage Inherits System.ComponentModel.Component Implements System.ComponentModel.IComponent, System.IDisposable
public class OraclePackage : System.ComponentModel.Component, System.ComponentModel.IComponent, System.IDisposable
This class is available only in Professional and Developer Editions. It is not available in Standard and Mobile Editions.
public void ExecuteStoredProc(OracleConnection conn) { OraclePackage package = new OraclePackage(); // Set active connection // Connection must be opened package.Connection = conn; // Set package name where stored procedure exists package.PackageName = "dbms_random"; // Execute procedure with parameters package.ExecuteProcedure("initialize", 10); // Execute procedure and return value object randomInt = package.ExecuteProcedure("random",typeof(Int)); // Print returned value Console.WriteLine(randomInt); // Execute procedure without parameters package.ExecuteProcedure("terminate"); }
Public Sub ExecuteStoredProc(conn As OracleConnection) Dim package As New OraclePackage() ' Set active connection ' Connection must be opened package.Connection = conn ' Set package name where stored procedure exists package.PackageName = "dbms_random" ' Execute procedure with parameters package.ExecuteProcedure("initialize", 10) ' Execute procedure and return value Dim randomInt As Object randomInt = package.ExecuteProcedure("random", GetType(Int)) ' Print returned value Console.WriteLine(randomInt) ' Execute procedure without parameters package.ExecuteProcedure("terminate") End Sub ' ExecuteStoredProc
System.Object
System.MarshalByRefObject
System.ComponentModel.Component
Devart.Data.Oracle.OraclePackage
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2