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
