news.omnitel.net wrote: > > 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
As written by Wolfgang: With SQLStudio the correct handling of dbprocs returning cursors WILL be available in the next version. --> Please use newest JDBC or the like. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
