動態返回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