Hello, thank you for sending a vtrace (outside the mailing list). It's a bug in the jdbc driver and will be fixed in the next version. The error only occurs when you use autocommit.
Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: Elke Schmidtke [mailto:[EMAIL PROTECTED]] > Sent: Dienstag, 8. Oktober 2002 15:27 > To: [EMAIL PROTECTED] > Subject: Problem with ResultSet from stored procedure > > > I want to get a ResultSet from a stored procedure, but don't > get any results. > The error message is: > com.sap.dbtech.jdbc.exceptions.NotSupportedException: SAP > DBTech JDBC: not supported > > My procedure should produce some rows in another tabel > depending on an input parameter. > This is my procedure: > create dbproc P_DBV_STUNDEN (in dbvnr int) returns cursor as > var beg_dat date; end_dat date; > stunden fixed (10,2); > begin > declare c cursor for select beginn from dba.T_ARBUMFANG where > DBV_NR=:dbvnr UNION select adddate(ende,1) from > dba.T_ARBUMFANG where DBV_NR=:dbvnr order by 1 asc; > FETCH C INTO :BEG_DAT; > WHILE $RC = 0 DO BEGIN > FETCH C INTO :END_DAT; > if $RC=100 then break; > SELECT SUM(STUNDEN) INTO :STUNDEN FROM DBA.T_ARBUMFANG > WHERE DBV_NR =:DBVNR AND > T_ARBUMFANG.BEGINN<=:BEG_DAT AND > SUBDATE(:END_DAT,1) <= T_ARBUMFANG.ENDE; > INSERT INTO dba.dbv_stunden VALUES (:DBVNR, :BEG_DAT, > SUBDATE(:END_DAT,1), :STUNDEN); > SET BEG_DAT=END_DAT; > END; > DECLARE :$CURSOR CURSOR FOR > select stunden,beginn,ende FROM dba.dbv_stunden where DBV_NR =:DBVNR; > end; > > The procedure works fine if I do not return cursor: the > expected rows are inserted in the table dba.dbv_stunden. > I also tried a more simple dbproc returning a ResultSet but > without success. > Procedures with output parameters do work. > I use the newest software (7.3.00.25) - kernel and jdbc driver. > > Can you help me ? > Elke > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
