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 -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
