Has some one tried to us SAP DB Stored procedures with syntax below?
CREATE DBPROC <procedure_name> [(<formal_parameter>,..)] RETURNS CURSOR AS <routine> I have problems with it. It simply does not work. Has someone suggestions how to create working stored procedure returning cursor? Test environment: DBM 7.4.3.10 SQL Studio 7.4 test source: CREATE DBPROC test_proc (IN result INTEGER) RETURNS CURSOR AS $CURSOR = 'HOTEL_CURSOR'; DECLARE :$CURSOR CURSOR FOR SELECT :result FROM DBA.DUAL; test rezults: call test_proc(1) "Statement successfully executed. No Result" expected rezults: One row in ouput _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
