On Wednesday 16 Oct 2002 10:51 am, you wrote:
> 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
Hi,
I did try the above. Nither jdbc nor websql are displaying the resultset. Do i
need to update my JDBC driver for SAPDB? i am using
sapdb-jdbc-bin-7.4.03.06a.jar.
--
Regards,
K. M. Kale
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
