1 of 1

ProcParam

Provide a paramater to a stored procudure.

Component Signature

<bx:ProcParam type=[string]
value=[any]
sqltype=[string]
maxLength=[integer]
scale=[integer]
null=[boolean] />

Attributes

Atrribute

Type

Required

Description

Default

type

string

false

The type of stored procedure paramter. One of in

out

value

any

false

The value to pass

sqltype

string

false

The sql type the value

string

maxLength

integer

false

scale

integer

false

null

boolean

false

If the value should be counted as null

Examples

Basic Example

<bx:storedproc procedure="foo_proc" dataSource="MY_SYBASE_TEST" username="sa" password="mygoodpw" dbServer="scup" dbName="pubs2" returnCode="Yes" debug="Yes">
<bx:procresult name="RS1"> 
<bx:procresult name="RS3" resultSet="3"> 
<bx:procparam type="IN" sqltype="INTEGER" value="1" dbVarName="@param1"> 
<bx:procparam type="OUT" sqltype="DATE" variable="FOO" dbVarName="@param2">
</bx:storedproc>