> > CREATE DBPROC scripts_that_print (IN tabStr VARCHAR(32), IN > whereStr VARCHAR(100)) > RETURNS CURSOR AS > VAR > stmt char(1000); > > $CURSOR = 'MY_CURSOR'; > stmt = 'SELECT MYCURSOR(*) FROM ' || tabstr || ' WHERE ' || wherestr; > execute stmt; > if ($rc <> 0) AND ($rc <> 100) THEN STOP ($rc); >
Great ! exactly what i needed. One last problem (probably not THE last) : I get an error with this : stmt = 'SELECT MY_CURSOR(Messag_id, Messag_titre)' ; stmt = stmt || ' FROM dba.T_Messagerie' ; EXECUTE stmt ; It says "Missing delimiter ; ". I guess it's because of the stmt = stmt || 'blabla' Do i really have to write my whole very long statement in one row ? Is there any special trick ? Thanx ! _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
