Jean-Michel OLTRA wrote : > bonjour,
>I'm trying to get a one row resultset in a OUT parameter within a >DBPROC with dynamic sql inside. >Sapdb version 7.4.3.27 >I read the archives and saw that it wasn't possible. >Is this still true ? >My dbproc fails.... You are asking for dynamic sql having parameters inside a db-procedure ? Sorry, this is still not possible. But you may return a cursor created by a dynamic sql statement. Example : create dbproc test returns cursor as var stmt char(50); $cursor = 'MYCURSOR'; stmt = 'DECLARE ' || $cursor || ' CURSOR FOR SELECT * FROM DUAL'; execute stmt; Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
