HI Thanx Anhaus
i tried it with all JDBC drivers but no luck... then i tried Andrew's solution with Jdbc driver . now its working... Thanx and Regards Naresh Chandak ----- Original Message ----- From: "Anhaus, Thomas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, April 02, 2002 1:43 PM Subject: RE:Problem with Executing Procedure > Naresh Chandak wrote : > >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 ? > > This is not a procedure that returns a cursor. If you want to create a > procedure > returning a cursor you have to use the following syntax : > > CREATE DBPROC USP_TEST (IN ID3 INTEGER ) RETURNS CURSOR AS > BEGIN > SET $CURSOR = 'MYCURSOR'; > DECLARE :$CURSOR FOR SELECT * FROM TP WHERE ID > :ID3 ; > END ; > > But as Marco already wrote this feature is still under construction. If you > use > an old JDBC driver you may have luck, but a call from SQL studio will > definitive return no result. > > Thomas > > --- > > Thomas Anhaus > SAPDB, SAP Labs Berlin > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
