On Wednesday 16 Oct 2002 10:51 am, you wrote: Thanks. Will try. I am using JDBC & websql both. Regards K. M. Kale > K. M. Kale > > >I have created a simple procedure like ... > >create dbproc test_select as select * from dba.test; > >when i call the dbproc i get... > >Statements successfully executed, no result ! > >Am i not suppose to get all rows in the table test? > >What am i doing wrong? > >Thanks in advance > >-- > > You have to declare that your db-procedure returns a cursor : > > create dbproc test_select returns cursor as select :$cursor (*) from > dba.test; > > Please note, that at the moment not all tools and programming languages > are already able to handle db-procedures which return a cursor. > For example, SQLStudio will not display > the resultset after calling the db-procedure. > > Thomas
-- K. M. Kale _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
