Hi Marco Thanks a lot I have already tested with JDBC-driver 7.3.0.20. / JDBC-driver 7.3.0.21. /JDBC-driver 7.3.0.23a. but unfortunately it doesnt work
when can I expect its working? Thanks And Regards Naresh Chandak ----- Original Message ----- From: "Paskamp, Marco" <[EMAIL PROTECTED]> To: "'Naresh Chandak'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 02, 2002 12:50 PM Subject: RE: Problem with Executing Procedure > Hello, > returning resultsets from procedures is a brand new, hidden feature of the > latest released version of sapdb and still in testing. In this version it > doesn't work very well together with our interfaces (odbc, jdbc). Maybe you > can use this feature with an old version of the JDBC-driver (< 7.3.0.21). > But at the moment I cannot recommend to use it in a production environment. > You should wait for the next version. > > Regards, > Marco > ---------------------------------------------- > Marco PASKAMP > SAP DB, SAP Labs Berlin > > > -----Original Message----- > > From: Naresh Chandak [mailto:[EMAIL PROTECTED]] > > Sent: Montag, 1. April 2002 10:59 > > To: [EMAIL PROTECTED] > > Subject: Problem with Executing Procedure > > > > > > Hi > > > > > > I am using sap db version 7.3.0.21 > > java driver version : sapdb-jdbc-bin-7.3.0.23a.jar > > sql studio version 7.3.1.0 > > > > I have a Table > > CREATE TABLE TP ( id INTEGER , name VARCHAR(50)) > > > > > > It has got following values > > > > INSERT INTO TP( id , name ) values (1 , 'a') > > INSERT INTO TP( id , name ) values (2 , 'b') > > INSERT INTO TP( id , name ) values (3 , 'c') > > INSERT INTO TP( id , name ) values (4 , 'd') > > INSERT INTO TP( id , name ) values (5 , 'e') > > > > I have a procedure.. > > > > CREATE DBPROC USP_TEST (IN ID3 INTEGER ) AS > > BEGIN > > SELECT * FROM TP WHERE ID > :ID3 ; > > END ; > > > > > > > > > > when I execute this procedure through sql studio ( CALL > > USP_TEST (1) ) > > It shows 'Statement successfully executed , No result found ' > > . But it should get 4 rows. > > > > same thing I tried with java. I got an exception 'SQL > > Statement generates a row count ' > > > > What should be the problem ? > > > > > > Thanks in advance > > > > Regards > > > > Naresh > > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
