Oracle Functions

Functions
hash	Qore::Oracle::bindOracleCollection (string tname, list values)
	returns a value to be used to bind a Qore value as an Oracle collection
hash	Qore::Oracle::bindOracleObject (string tname, hash values)
	returns a value to be used to bind a Qore value as an Oracle object
hash	Qore::Oracle::placeholderOracleCollection (string tname)
	returns a value to be used to describe a placeholder buffer for retrieving an Oracle collection as an output value
hash	Qore::Oracle::placeholderOracleObject (string tname)
	returns a value to be used to describe a placeholder buffer for retrieving an Oracle object as an output value

Detailed Description

Function Documentation

hash Qore::Oracle::bindOracleCollection	(	string	tname,
		list	values
	)

returns a value to be used to bind a Qore value as an Oracle collection

Code Flags:

CONSTANT

Parameters

tname	the name of the Oracle collection type to bind
values	a list of values for the collection

Returns

a hash value which can be used to bind the given value as the given collection in an SQL statement with the following keys:

• "type": a constant string "OracleCollection"
• "^oratype^": the value of the tname argument
• "^values^": the value of the values argument

Example:

$db.exec("insert into object_table (obj) values (%v)", bindOracleObject("MY_OBJECT", $h));

hash Qore::Oracle::bindOracleObject	(	string	tname,
		hash	values
	)

returns a value to be used to bind a Qore value as an Oracle object

Code Flags:

CONSTANT

Parameters

tname	the name of the Oracle type to bind
values	a hash where the keys are Oracle object attributes

Returns

a hash value which can be used to bind the given value as the given object in an SQL statement with the following keys:

• "type": a constant string "OracleObject"
• "^oratype^": the value of the tname argument
• "^values^": the value of the values argument

Example:

$db.exec("insert into object_table (obj) values (%v)", bindOracleObject("MY_OBJECT", $h));

hash Qore::Oracle::placeholderOracleCollection

(

string

tname

)

returns a value to be used to describe a placeholder buffer for retrieving an Oracle collection as an output value

Code Flags:

CONSTANT

Parameters

tname

the name of the Oracle collection type to bind for the placeholder buffer

Returns

a hash value which can be used to describe an output placeholder buffer as a collection buffer of the given type in an SQL statement with the following keys:

• "type": a constant string "OracleCollection"
• "value": the value of the tname argument

Example:

my hash $h = $db.exec("begin my_pkg.get_collection(:retval); end;", placeholderOracleCollection("MY_COLLECTION")).retval;

hash Qore::Oracle::placeholderOracleObject

(

string

tname

)

returns a value to be used to describe a placeholder buffer for retrieving an Oracle object as an output value

Code Flags:

CONSTANT

Parameters

tname

the name of the Oracle object type to bind for the placeholder buffer

Returns

a hash value which can be used to describe an output placeholder buffer as an object buffer of the given type in an SQL statement with the following keys:

• "type": a constant string "OracleObject"
• "value": the value of the tname argument

Example:

my hash $h = $db.exec("begin my_pkg.get_obj(:retval); end;", placeholderOracleObject("MY_OBJECT")).retval;