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
