下面这一段是国外针对先前问题的回答,也没测试,不知道怎么样。Hi,Were using Oracle here but I've managed to use the equivalent of FETCH FIRST n ROWS. The sql string is SET sql = 'SELECT DATA_KEY, DATA_VALUE FROM esb.ENVIRONMENT_VALUES WHERE ENVIRONMENT = ?...
显示全部下面这一段是国外针对先前问题的回答,也没测试,不知道怎么样。
Hi,
Were using Oracle here but I've managed to use the equivalent of FETCH FIRST n ROWS. The sql string is
SET sql = 'SELECT DATA_KEY, DATA_VALUE FROM esb.ENVIRONMENT_VALUES WHERE ENVIRONMENT = ? AND ROWNUM <= ?';
We create an array called DB_IN_PARAMS of all the parameters
SET DB_IN_PARAMS.PARAM1 = 'ALL';
SET DB_IN_PARAMS.PARAM2 = 2;
We then issue the PASSTHRU statment
Passthru(sql, DB_IN_PARAMS.[]);
Have you checked the syntax of your SQL statement ? Are the parameters your passing through an INTEGER for the number of rows ?
收起