Hi,
I have defined the column variable and record variable in DB data block
AppState.DBDataWL_VIP1777, AppState.DBDataWL_VIP1777compteur
Please find below vxml code
<?xml version="1.0" encoding="utf-8"?>
<!-- VXML code generated by Composer 8.1.540.07 -->
<!-- Diagram created by Composer: Composer 8.1.541.07 -->
<!-- Project version: 8.1.541.07 -->
<!-- Diagram version: 1.0 CreatedOn: -->
<!-- Application Author: -->
<!-- Release Mode: false -->
<!-- Global Scripts includes -->
<script src="../include/common.js" />
<script src="../include/ctic.js" />
<script src="../include/json.js" />
<script src="../include/DataAccess.js" />
<!-- Global Vars declarations -->
<script>
var AppState = new Object();
AppState.System = new Object();
AppState.System.RetainInputTypeVariableDefaultValue = false;
AppState.CallUUID = session.connection.uuid;
AppState.ANI = getANI();
AppState.DNIS = getDNIS();
AppState.USE_LCASE_USERDATAKEY = initSystemTypeVariable('USE_LCASE_USERDATAKEY',0);
if (session.connection.protocol.sip.headers != undefined &&
session.connection.protocol.sip.headers['x-genesys-gvp-session-id']){
AppState.GVPSessionID = session.connection.protocol.sip.headers['x-genesys-gvp-session-id'];
AppState.g_CTICCall = isCTICCall(AppState.GVPSessionID);
} else {
AppState.GVPSessionID = 'undefined';
AppState.g_CTICCall = 'false';
}
AppState.APP_ASR_LANGUAGE = initSystemTypeVariable('APP_ASR_LANGUAGE','en-US');
AppState.APP_LANGUAGE = initSystemTypeVariable('APP_LANGUAGE','en-US');
AppState.APP_OPM = initSystemTypeVariable('APP_OPM',eval('('+session.connection.protocol.sip.requesturi['parameters']+')'));
AppState.ChoixMenu = undefined;
AppState.COMPOSER_WSSTUBBING = initSystemTypeVariable('COMPOSER_WSSTUBBING','0');
AppState.dummy = '';
AppState.EnableFCR = initSystemTypeVariable('EnableFCR',true);
AppState.EnableReports = initSystemTypeVariable('EnableReports',false);
AppState.EnableSNMP = initSystemTypeVariable('EnableSNMP',false);
AppState.GRAMMARFILEDIR = initSystemTypeVariable('GRAMMARFILEDIR','../Resources/Grammars');
AppState.ivr_route = 'ACC';
AppState.LAST_EVENT_ELEMENT = initSystemTypeVariable('LAST_EVENT_ELEMENT','undefined');
AppState.LAST_EVENT_LINE = initSystemTypeVariable('LAST_EVENT_LINE','undefined');
AppState.LAST_EVENT_MSG = initSystemTypeVariable('LAST_EVENT_MSG','undefined');
AppState.LAST_EVENT_NAME = initSystemTypeVariable('LAST_EVENT_NAME','undefined');
AppState.LAST_EVENT_URL = initSystemTypeVariable('LAST_EVENT_URL','undefined');
AppState.msisdn = '';
AppState.numentered = undefined;
AppState.OCS_Record = initSystemTypeVariable('OCS_Record',getCallflowOCSRecord());
AppState.OCS_RecordURI = initSystemTypeVariable('OCS_RecordURI',getCallflowRecordURI());
AppState.OCS_URI = initSystemTypeVariable('OCS_URI',getCallflowOCSURI());
AppState.PREV_APP_ASR_LANGUAGE = initSystemTypeVariable('PREV_APP_ASR_LANGUAGE','undefined');
AppState.PREV_APP_LANGUAGE = initSystemTypeVariable('PREV_APP_LANGUAGE','undefined');
AppState.SCRIPTSDIR = initSystemTypeVariable('SCRIPTSDIR','../Scripts');
AppState.svi_lang = undefined;
AppState.VOXFILEDIR = initSystemTypeVariable('VOXFILEDIR','../Resources/Prompts');
AppState.clientidentif = undefined;
AppState.choixsortie = undefined;
AppState.var_ConnectionString = undefined;
AppState.var_Stored_Set = 0;
AppState.var_Stored_Record = undefined;
AppState.var_Filter_Column = undefined;
AppState.var_msisdn = '';
AppState.DBDataWL_VIP1777compteur = undefined;
AppState.DBDataWL_VIP1777 = undefined;
AppState.DBDataWL_VIP1777_mapping = [];
</script>
<!-- Global Scripts -->
<script srcexpr="AppState.VOXFILEDIR + '/PromptSwitch.js'" />
<script srcexpr="AppState.VOXFILEDIR + '/en-US/en-US.js'" />
<script>var f = new Format();</script>
<script srcexpr="AppState.VOXFILEDIR + '/en-US/customprompts.js'" />
<!-- Global Properties declarations -->
<property name="com.genesyslab.logtoasr" value="false" />
<property name="com.genesyslab.loglevel" value="5" />
<!-- Metadata information -->
<meta name="com.genesyslab.studio.resourcePath" content="/Callflows/Main.callflow"/>
<!-- Global links -->
<form>
<block>
<log expr="'Running Main workflow.'"/>
<log expr="'Code Generated by Composer: 8.1.540.07.'"/>
<log expr="'Diagram created/upgraded by Composer: Composer 8.1.541.07.'"/>
<log expr="'Project version: 8.1.541.07.'"/>
<log expr="'Diagram version: 1.0 CreatedOn: .'"/>
<goto next="#Entry1" />
</block>
</form>
<!-- This is the Entry block -->
<form id="Entry1">
<block name="Entry">
<goto next="#Assign2" />
</block>
</form>
<catch event="connection.disconnect.hangup">
<assign name="AppState.LAST_EVENT_ELEMENT" expr="_element"/>
<assign name="AppState.LAST_EVENT_MSG" expr="_message"/>
<assign name="AppState.LAST_EVENT_NAME" expr="_event"/>
<assign name="AppState.LAST_EVENT_LINE" expr="_line"/>
<assign name="AppState.LAST_EVENT_URL" expr="_url"/>
<script>storeCallflowException(_element, _message, _event, _line, _url)</script>
<goto next="#ActionStart2" />
</catch>
<catch event="error">
<assign name="AppState.LAST_EVENT_ELEMENT" expr="_element"/>
<assign name="AppState.LAST_EVENT_MSG" expr="_message"/>
<assign name="AppState.LAST_EVENT_NAME" expr="_event"/>
<assign name="AppState.LAST_EVENT_LINE" expr="_line"/>
<assign name="AppState.LAST_EVENT_URL" expr="_url"/>
<script>storeCallflowException(_element, _message, _event, _line, _url)</script>
<goto next="#ActionStart2" />
</catch>
<catch event=".">
<assign name="AppState.LAST_EVENT_ELEMENT" expr="_element"/>
<assign name="AppState.LAST_EVENT_MSG" expr="_message"/>
<assign name="AppState.LAST_EVENT_NAME" expr="_event"/>
<assign name="AppState.LAST_EVENT_LINE" expr="_line"/>
<assign name="AppState.LAST_EVENT_URL" expr="_url"/>
<script>storeCallflowException(_element, _message, _event, _line, _url)</script>
<goto next="#ActionStart2" />
</catch>
<!-- This is the Exit block -->
<form id="Exit1">
<block>
<exit/>
</block>
</form>
<!-- This is the Assign block -->
<form id="French">
<block>
<assign name="AppState.svi_lang" expr="'FR'" />
<goto next="#HNO?" />
</block>
</form>
<!-- This is the Assign block -->
<form id="English">
<block>
<assign name="AppState.svi_lang" expr="'EN'" />
<goto next="#HNO?" />
</block>
</form>
<!-- This is the ActionStartBlock block -->
<form id="ActionStart1">
<block>
<log label="com.genesyslab.var.ActionStart" gvp:cond="AppState.EnableReports">1222_Start|parentID=Main</log>
<goto next="#ActionEnd1" />
</block>
</form>
<!-- This is the ActionEndBlock block -->
<form id="ActionEnd1">
<block>
<log label="com.genesyslab.var.ActionEnd" gvp:cond="AppState.EnableReports">1222_Start|UNKNOWN</log>
<goto next="#ECMAScript1" />
</block>
</form>
<!-- This is the ActionStartBlock block -->
<form id="ActionStart2">
<block>
<log label="com.genesyslab.var.ActionStart" gvp:cond="AppState.EnableReports">1222_Deconnexion_Debut</log>
<goto next="#ActionEnd2" />
</block>
</form>
<!-- This is the ActionEndBlock block -->
<form id="ActionEnd2">
<block>
<log label="com.genesyslab.var.ActionEnd" gvp:cond="AppState.EnableReports">1222_Deconnexion_Debut|UNKNOWN</log>
<goto next="#Exit1" />
</block>
</form>
<!-- This is the ActionStartBlock block -->
<form id="ActionStart3">
<block>
<log label="com.genesyslab.var.ActionStart" gvp:cond="AppState.EnableReports">1222_English|parentID=Main</log>
<goto next="#ActionEnd3" />
</block>
</form>
<!-- This is the ActionStartBlock block -->
<form id="ActionStart4">
<block>
<log label="com.genesyslab.var.ActionStart" gvp:cond="AppState.EnableReports">1222_French|parentID=Main</log>
<goto next="#ActionEnd4" />
</block>
</form>
<!-- This is the ActionEndBlock block -->
<form id="ActionEnd3">
<block>
<log label="com.genesyslab.var.ActionEnd" gvp:cond="AppState.EnableReports">1222_English|UNKNOWN</log>
<goto next="#English" />
</block>
</form>
<!-- This is the ActionEndBlock block -->
<form id="ActionEnd4">
<block>
<log label="com.genesyslab.var.ActionEnd" gvp:cond="AppState.EnableReports">1222_French|UNKNOWN</log>
<goto next="#French" />
</block>
</form>
<!-- This is the InteractionDataBlock block -->
<form id="InteractionData1">
<property name="com.genesyslab.externalevents.enable" value="false"/>
<property name="com.genesyslab.externalevents.queue" value="true"/>
<block>
<if cond="AppState.g_CTICCall == 'false'" >
<script>
var choixsortie = AppState.choixsortie;
</script>
<gvp:send namelist="choixsortie" async="false"/>
<else/>
<!-- CTIC Case -->
<script>
var Action = "AttachData";
var sub_action = "Add";
var choixsortie = AppState.choixsortie;
</script>
<gvp:send namelist="Action sub_action choixsortie" async="false"/>
<gvp:receive maxtime="10s"/>
<if cond="isCTICResult( application.lastmessage$ ) == 'false'">
<throw event="error.com.genesyslab.composer.receiveerror" messageexpr="'The received message has invalid content-type.'" />
</if>
<var name="InteractionData1Message" expr="application.lastmessage$.content"/>
<var name="arrUserData" expr="getUserDataArray(InteractionData1Message)"/>
<var name="InteractionData1Result" expr="utilGetReceiveDataValue('Result', arrUserData)" />
<if cond="InteractionData1Result != 'SUCCESS'">
<var name="InteractionData1ResultReason" expr="utilGetReceiveDataValue('reason', arrUserData)" />
<if cond="InteractionData1ResultReason == 'Timeout'">
<throw event="error.com.genesyslab.composer.operationtimeout" messageexpr="InteractionData1ResultReason" />
<else/>
<throw event="error.com.genesyslab.composer.receiveerror" messageexpr="InteractionData1ResultReason" />
</if>
</if>
</if>
<goto next="#Exit1" />
</block>
</form>
<!-- This is the DB Data block -->
[b]<form id="DBDataWL_VIP1777">[/b]
<block>
<log gvp:level="1">
<value expr="'Inside the DB data Block'"/>
</log>
<log gvp:level="1">
<value expr="'Result of First variable'+AppState.DBDataWL_VIP1777compteur"/>
</log>
<log gvp:level="1">
<value expr="'Result of Second Variable'+AppState.DBDataWL_VIP1777"/>
</log>
</block>
<var name="AppStateString" expr="'(' + JSON.stringify(AppState) + ')'" />
<var name="db_query_type" expr="'StoredProcedure'" />
<!-- branch off based on the query type: SQL Query, Query File or Stored Procedure -->
<var name="db_query" expr="'Main_DBDataWL_VIP1777.sql'" />
<!-- Define parameters to be used for stored procedure prepared statement -->
<var name="sp_param_RETURN_VALUE" expr="'return$$INTEGER$${var_Filter_Column}'" />
<!-- Define parameters to be used for stored procedure prepared statement -->
<var name="sp_param_proc_ani" expr="'input$$CHAR$${var_msisdn}'" />
<!-- Define parameters to be used for stored procedure prepared statement -->
<var name="sp_param_compteur" expr="'inout$$CHAR$${var_Stored_Set}'" /><var name="sp_param_list" expr="' RETURN_VALUE proc_ani compteur'"/>
<var name="db_name" expr="'ConnectionProfile'" />
<var name="db_timeout" expr="20" />
<script>
var connProps = new Object();
var customParameters = new Object();
connProps['customParameters'] = customParameters;
</script>
<var name="ConnPropString" expr="'(' + JSON.stringify(connProps) + ')'" />
<block>
<data name="DBDataWL_VIP1777Data" src="../include/dbrequest.jsp" method="post"
namelist="AppStateString db_query db_query_type db_name db_timeout ConnPropString sp_param_list sp_param_RETURN_VALUE sp_param_proc_ani sp_param_compteur"
enctype="multipart/form-data"
fetchtimeout="22s"/>
<if cond="typeof DBDataWL_VIP1777Data.errorMsg == 'undefined'">
<if cond="typeof DBDataWL_VIP1777Data.db_result != 'undefined'">
<assign name="AppState.DBDataWL_VIP1777" expr="DBDataWL_VIP1777Data.db_result" />
<assign name="AppState.DBDataWL_VIP1777compteur" expr="DBDataWL_VIP1777Data.db_result_columns" />
</if>
<if cond="typeof DBDataWL_VIP1777Data.db_outparams != 'undefined'">
<log expr="'db_outparams:' + DBDataWL_VIP1777Data.db_outparams"/>
<assign name="AppState.var_Filter_Column" expr="DBDataWL_VIP1777Data.db_outparams.RETURN_VALUE" />
<assign name="AppState.var_Stored_Set" expr="DBDataWL_VIP1777Data.db_outparams.compteur" />
</if>
<goto next="#ECMAScript2" />
<else/>
<if cond="typeof DBDataWL_VIP1777Data.errorType != 'undefined'">
<if cond="DBDataWL_VIP1777Data.errorType == 'timeout'">
<throw event="error.com.genesyslab.composer.dbtimeout" messageexpr="DBDataWL_VIP1777Data.errorMsg" />
<elseif cond="DBDataWL_VIP1777Data.errorType == 'connectionerror'" />
<throw event="error.com.genesyslab.composer.dbconnectionerror" messageexpr="DBDataWL_VIP1777Data.errorMsg" />
</if>
<else/>
<throw event="error.com.genesyslab.composer.dberror" messageexpr="DBDataWL_VIP1777Data.errorMsg" />
</if>
</if>
</block>
<catch event="error.com.genesyslab.composer.dberror">
<script>storeCallflowException(_element, _message, _event, _line, _url)</script>
<goto next="#Br_Identif" />
</catch>
<catch event="error.com.genesyslab.composer.dbemptyresultset">
<script>storeCallflowException(_element, _message, _event, _line, _url)</script>
<goto next="#Br_Identif" />
</catch>
<catch event="error.com.genesyslab.composer.dbtimeout">
<script>storeCallflowException(_element, _message, _event, _line, _url)</script>
<goto next="#Br_Identif" />
</catch>
<catch event="error.com.genesyslab.composer.dbconnectionerror">
<script>storeCallflowException(_element, _message, _event, _line, _url)</script>
<goto next="#Br_Identif" />
</catch>
<catch event="error.com.genesyslab.composer.variablemappingerror">
<script>storeCallflowException(_element, _message, _event, _line, _url)</script>
<goto next="#Br_Identif" />
</catch>
</form>
<!-- This is the Branching block -->
<form id="Br_Identif">
<block>
<if cond="AppState.clientidentif=='OK'">
<!-- This is the OutLink -->
<goto next="#AccueilChoixLang" />
</if>
<if cond="AppState.clientidentif=!'OK'">
<!-- This is the OutLink -->
<goto next="#MsgIdentif" />
</if>
<goto next="#MsgIdentif" />
</block>
</form>
<!-- This is the ActionEndBlock block -->
<form id="ActionEnd5">
<block>
<log label="com.genesyslab.var.ActionEnd" gvp:cond="AppState.EnableReports">1222_VoixSms|UNKNOWN</log>
<goto next="#Assign1" />
</block>
</form>
<!-- This is the Assign block -->
<form id="Assign1">
<block>
<assign name="AppState.choixsortie" expr="'VoixSms'" />
<goto next="#InteractionData1" />
</block>
</form>
<!-- This is the ActionStartBlock block -->
<form id="ActionStart5">
<block>
<log label="com.genesyslab.var.ActionStart" gvp:cond="AppState.EnableReports">1222_VoixSms</log>
<goto next="#ActionEnd5" />
</block>
</form>
<!-- This is the Assign block -->
<form id="Assign3">
<block>
<assign name="AppState.choixsortie" expr="'OM'" />
<goto next="#InteractionData1" />
</block>
</form>
<!-- This is the ActionEndBlock block -->
<form id="ActionEnd6">
<block>
<log label="com.genesyslab.var.ActionEnd" gvp:cond="AppState.EnableReports">1222_OM|UNKNOWN</log>
<goto next="#Assign3" />
</block>
</form>
<!-- This is the ActionStartBlock block -->
<form id="ActionStart6">
<block>
<log label="com.genesyslab.var.ActionStart" gvp:cond="AppState.EnableReports">1222_OM</log>
<goto next="#ActionEnd6" />
</block>
</form>
<!-- This is the ActionStartBlock block -->
<form id="ActionStart7">
<block>
<log label="com.genesyslab.var.ActionStart" gvp:cond="AppState.EnableReports">1222_Internet|parentID=Main</log>
<goto next="#ActionEnd7" />
</block>
</form>
<!-- This is the Assign block -->
<form id="Assign4">
<block>
<assign name="AppState.choixsortie" expr="'Internet'" />
<goto next="#InteractionData1" />
</block>
</form>
<!-- This is the ActionEndBlock block -->
<form id="ActionEnd7">
<block>
<log label="com.genesyslab.var.ActionEnd" gvp:cond="AppState.EnableReports">1222_Internet|UNKNOWN</log>
<goto next="#Assign4" />
</block>
</form>
<!-- This is the Exit block -->
<form id="Exit2">
<block>
<exit/>
</block>
</form>
<!-- This is the ActionEndBlock block -->
<form id="ActionEnd9">
<block>
<log label="com.genesyslab.var.ActionEnd" gvp:cond="AppState.EnableReports">1222_Lingala|UNKNOWN</log>
<goto next="#Lingala" />
</block>
</form>
<!-- This is the Assign block -->
<form id="Lingala">
<block>
<assign name="AppState.svi_lang" expr="'LI'" />
<goto next="#HNO?" />
</block>
</form>
<!-- This is the ActionStartBlock block -->
<form id="ActionStart9">
<block>
<log label="com.genesyslab.var.ActionStart" gvp:cond="AppState.EnableReports">1222_Lingala</log>
<goto next="#ActionEnd9" />
</block>
</form>
<!-- This is the Assign block -->
<form id="Swahili">
<block>
<assign name="AppState.svi_lang" expr="'SW'" />
<goto next="#HNO?" />
</block>
</form>
<!-- This is the ActionStartBlock block -->
<form id="ActionStart10">
<block>
<log label="com.genesyslab.var.ActionStart" gvp:cond="AppState.EnableReports">1222_Swahili</log>
<goto next="#ActionEnd10" />
</block>
</form>
<!-- This is the ActionEndBlock block -->
<form id="ActionEnd10">
<block>
<log label="com.genesyslab.var.ActionEnd" gvp:cond="AppState.EnableReports">1222_Swahili|UNKNOWN</log>
<goto next="#Swahili" />
</block>
</form>
<!-- This is the ActionStartBlock block -->
<form id="ActionStart11">
<block>
<log label="com.genesyslab.var.ActionStart" gvp:cond="AppState.EnableReports">1222_Tshiluba</log>
<goto next="#ActionEnd11" />
</block>
</form>
<!-- This is the Assign block -->
<form id="Tshiluba">
<block>
<assign name="AppState.svi_lang" expr="'TS'" />
<goto next="#HNO?" />
</block>
</form>
<!-- This is the ActionEndBlock block -->
<form id="ActionEnd11">
<block>
<log label="com.genesyslab.var.ActionEnd" gvp:cond="AppState.EnableReports">1222_Tshiluba|UNKNOWN</log>
<goto next="#Tshiluba" />
</block>
</form>
<!-- This is the Assign block -->
<form id="Kikongo">
<block>
<assign name="AppState.svi_lang" expr="'KI'" />
<goto next="#HNO?" />
</block>
</form>
<!-- This is the ActionEndBlock block -->
<form id="ActionEnd12">
<block>
<log label="com.genesyslab.var.ActionEnd" gvp:cond="AppState.EnableReports">1222_Kikongo|UNKNOWN</log>
<goto next="#Kikongo" />
</block>
</form>
<!-- This is the ActionStartBlock block -->
<form id="ActionStart12">
<block>
<log label="com.genesyslab.var.ActionStart" gvp:cond="AppState.EnableReports">1222_Kikongo</log>
<goto next="#ActionEnd12" />
</block>
</form>
<!-- This is the Log block -->
<form id="Log1">
<block>
<goto next="#Br_Identif" />
</block>
</form>
<!-- This is the Assign block -->
<form id="ECMAScript1">
<block>
<script>
try {
// your code
AppState.var_msisdn=AppState.ANI;
__Log('The ANI value is '+AppState.var_msisdn);
AppState.var_msisdn='"' + AppState.var_msisdn + '"';
__Log('The ANI value in string '+AppState.var_msisdn);
} catch (error) {
// error handling code
}
</script>
<goto next="#DBDataWL_VIP1777" />
</block>
</form>
<!-- This is the Assign block -->
<form id="ECMAScript2">
<block>
<script>
try {
// your code
AppState.var_Stored_Set= JSON.stringify(DBDataWL_VIP1777Data.db_outparams.compteur);
__Log('Result of Stored Procedure'+AppState.var_Stored_Set);
} catch (error) {
// error handling code
__Log('Code Failure');
}
</script>
<goto next="#Log1" />
</block>
</form>
<!-- This is the AccueilChoixLang block in Disabled mode -->
<form id="AccueilChoixLang">
<block>
<goto next="#ActionStart4" />
</block>
</form>
<!-- This is the Assign2 block in Disabled mode -->
<form id="Assign2">
<block>
<goto next="#ActionStart1" />
</block>
</form>
<!-- This is the MsgIdentif block in Disabled mode -->
<form id="MsgIdentif">
<block>
<goto next="#Exit2" />
</block>
</form>
<!-- This is the HNO? block in Disabled mode -->
<form id="HNO?">
<block>
<goto next="#MessClosed" />
</block>
</form>
<!-- This is the MessClosed block in Disabled mode -->
<form id="MessClosed">
<block>
<goto next="#Exit2" />
</block>
</form>
<!-- This is the Qualification block in Disabled mode -->
<form id="Qualification">
<block>
</block>
</form>