GetVariable Method

On this page

Returns a value of the variable in the package mapped to the specified type.

Syntax

Visual Basic
C#


'Declaration Public Function GetVariable( _ ByVal variableName As String, _ ByVal dbType As OracleDbType _ ) As Object


public object GetVariable( string variableName, OracleDbType dbType )

Parameters

variableName: Name of the variable in the package.
dbType: One of the OracleDbType values.

Return Value

A value of the variable in the package.

Remarks

Use GetVariable method to obtain the value of a package variable or constant declared within Oracle package. If the name does not exist an exception will be thrown.

Example

The following example obtains and then prints the variable value.

csharp


public void GetPackageVariableValue(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 = "oranet_pack"; // Get variable value object pkgVar = package.GetVariable("package_variable", OracleDbType.VarChar); // Print variable value Console.WriteLine(pkgVar); // Set variable to specific value package.SetVariable("package_variable", "test string"); // Get variable value pkgVar = package.GetVariable("package_variable", OracleDbType.VarChar); // Print variable value Console.WriteLine(pkgVar); }

public void GetPackageVariableValue(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 = "oranet_pack";

  // Get variable value
  object pkgVar = package.GetVariable("package_variable", OracleDbType.VarChar);

  // Print variable value
  Console.WriteLine(pkgVar);

  // Set variable to specific value
  package.SetVariable("package_variable", "test string");

  // Get variable value
  pkgVar = package.GetVariable("package_variable", OracleDbType.VarChar);

  // Print variable value
  Console.WriteLine(pkgVar);
}

Visual Basic


Public Sub GetPackageVariableValue(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 = "oranet_pack" ' Get variable value Dim pkgVar As Object pkgVar = package.GetVariable("package_variable", OracleDbType.VarChar) ' Print variable value Console.WriteLine(pkgVar) ' Set variable to specific value package.SetVariable("package_variable", "test string") ' Get variable value pkgVar = package.GetVariable("package_variable", OracleDbType.VarChar) ' Print variable value Console.WriteLine(pkgVar) End Sub 'GetPackageVariableValue

Public Sub GetPackageVariableValue(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 = "oranet_pack"

  ' Get variable value
  Dim pkgVar As Object
  pkgVar = package.GetVariable("package_variable", OracleDbType.VarChar)

  ' Print variable value
  Console.WriteLine(pkgVar)

  ' Set variable to specific value
  package.SetVariable("package_variable", "test string")

  ' Get variable value
  pkgVar = package.GetVariable("package_variable", OracleDbType.VarChar)

  ' Print variable value
  Console.WriteLine(pkgVar)
End Sub 'GetPackageVariableValue

Reference

OraclePackage Class
OraclePackage Members

Send Feedback