Struct BindParam 

pub struct BindParam {
    pub value: Option<Value>,
    pub direction: BindDirection,
    pub oracle_type: OracleType,
    pub buffer_size: u32,
}

A bind parameter for PL/SQL execution with direction support

This struct allows specifying IN, OUT, and IN OUT parameters for PL/SQL calls.

Examples

use oracle_rs::{BindParam, BindDirection, OracleType, Value};

// IN parameter (default)
let in_param = BindParam::input(Value::Integer(42));

// OUT parameter - specify the expected type and size
let out_param = BindParam::output(OracleType::Varchar, 100);

// IN OUT parameter
let inout_param = BindParam::input_output(Value::String("hello".into()), 100);

// Execute PL/SQL
let results = conn.execute_plsql(
    "BEGIN :1 := :2 * 2; END;",
    &[out_param, in_param]
).await?;

Fields

value: Option<Value>

The value (None for pure OUT parameters)

direction: BindDirection

Parameter direction

oracle_type: OracleType

Oracle type (required for OUT parameters)

buffer_size: u32

Buffer size for OUT parameters

Implementations

impl BindParam

pub fn input(value: Value) -> Self

Create an IN (input) parameter from a value

pub fn output(oracle_type: OracleType, buffer_size: u32) -> Self

Create an OUT (output) parameter with the expected type and size

pub fn output_cursor() -> Self

Create an OUT parameter for a REF CURSOR

pub fn output_collection(obj_type: &DbObjectType) -> Self

Create an OUT parameter for a collection (VARRAY, Nested Table)

The DbObjectType provides element type information for proper decoding.

pub fn input_collection(obj_type: &DbObjectType, collection: DbObject) -> Self

Create an IN parameter for a collection (VARRAY, Nested Table)

The DbObjectType provides element type information for proper encoding, and the DbObject contains the actual element values.

Example

let varray_type = conn.get_type("NUMBER_VARRAY").await?;
let mut coll = DbObject::collection("NUMBER_VARRAY");
coll.append(Value::Integer(1));
coll.append(Value::Integer(2));
let param = BindParam::input_collection(&varray_type, coll);

pub fn input_output(value: Value, buffer_size: u32) -> Self

Create an IN OUT (input/output) parameter

pub fn placeholder_value(&self) -> Value

Create a placeholder value for OUT parameters based on the Oracle type This is used when sending bind metadata to the server

Trait Implementations

impl Clone for BindParam

fn clone(&self) -> BindParam

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for BindParam

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl From<&str> for BindParam

fn from(v: &str) -> Self

Converts to this type from the input type.

impl From<String> for BindParam

fn from(v: String) -> Self

Converts to this type from the input type.

impl From<Value> for BindParam

fn from(value: Value) -> Self

Converts to this type from the input type.

impl From<bool> for BindParam

fn from(v: bool) -> Self

Converts to this type from the input type.

impl From<f64> for BindParam

fn from(v: f64) -> Self

Converts to this type from the input type.

impl From<i32> for BindParam

fn from(v: i32) -> Self

Converts to this type from the input type.

impl From<i64> for BindParam

fn from(v: i64) -> Self

Converts to this type from the input type.