Hi Radhika,
DB GET steps in IVR requires localvariables to be mapped against FieldNames. For MS-SQL2000, CRA editor supports all SQL datatypes except
NCHAR
NTEXT
NVARCHAR
SQL_VARIANT
UNIQUEIDENTIFIER
You can create custom steps / classes for advance database scripting.
For CRA 3.0 and above, the documentation comes along with the CRA software package. Check the same in CRA Server under
Start->Programs->Cisco CRA Administrator->Component Developers Guide.
For 2.2 refer the following URL
http://www.cisco.com/univercd/cc/td/doc/product/voice/sw_ap_to/apps_22/dev_gd/sdkdeplo.pdf
Regards
Yogi