OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Bug? Stored procedures with RETURNS CURSOR does not work

From: news.omnitel.net (pranashotmail.com)
Date: Thu Jul 03 2003 - 05:04:03 CDT

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
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general