動態返回DECIMAL,string類型函數

返回類型:decimal

參數：string exec_sql

Decimal RetVal

DECLARE tmp_cur DYNAMIC CURSOR FOR SQLSA;
PREPARE SQLSA FROM :exec_sql;
OPEN DYNAMIC tmp_cur;
FETCH tmp_cur INTO :RetVal;
CLOSE tmp_cur;

If bLogEnabled = TRUE Then
syslog.log("GF_EXEC_SQL_RET_DECIMAL:SQL", exec_sql)
End If

Return RetVal

--------------------------

--------------------------

返回類型：string

參數：string exec_sql

String RetVal;

DECLARE tmp_cur DYNAMIC CURSOR FOR SQLSA;

PREPARE SQLSA FROM :exec_sql;

OPEN DYNAMIC tmp_cur;

FETCH tmp_cur INTO :RetVal;

CLOSE tmp_cur;

If bLogEnabled = TRUE Then
syslog.log("GF_EXEC_SQL_RET_STRING:SQL", exec_sql)
End If

Return RetVal