'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