SetVariable Method

In This Topic

Syntax
Remarks
Example
See Also

Assigns specified value to a variable from the package.

Syntax

Visual Basic
C#

public void SetVariable( 
   string variableName,
   object value
)

'Declaration
 
Public Sub SetVariable( _
   ByVal variableName As String, _
   ByVal value As Object _
)

Parameters

variableName: Name of the variable in the package.
value: A value that will be assigned to the variable.

Remarks

Use SetVariable method to set 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 sets the new 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);
}

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

Reference

OraclePackage Class
OraclePackage Members

Send Feedback