Hi all ! I tried this in order to get a LIMIT X,Y function like in mysql:
CREATE DBPROC DBA.TEST4 (IN start INTEGER, IN stop INTEGER) AS VAR Z INTEGER ; SET Z = 0 ; SELECT TESTSEQ.CURRVAL FROM DBA.DUAL ; FETCH INTO :Z ; SELECT * FROM (SELECT LANG_ID, LANG_LIBELLE,(TESTSEQ.NEXTVAL - :Z) NBR FROM DBA.T_LANGUE) WHERE NBR BETWEEN :START AND :STOP ; But i get this error : 10:44:25 [CALL - 0 rows, 0.020 sec] [-4000] (at 96): Unknown result table what is that result table ??? -- Marc-Olivier Meunier Ing�nieur Projet BKLINK MVH-IRIS 14, rue Rougemont 75009 Paris _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
