Marc-Olivier Meunier wrote: > > 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 ???
When does this error occurs? If you create the dbproc, if you call it, if you want to receive the results of the dbproc? creation and calling worked for me. And receiving the results is not possible because you did not specify that this dbproc should return a resultset/cursor whose FETCH-statements will be done outside the dbproc. Please check the reference manual/ the archive for the syntax for returning a cursor out of a dbproc. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
