OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
RE: Bug? Stored procedures with RETURNS CURSOR does not work

From: Zabach, Elke (elke.zabachsap.com)
Date: Thu Jul 03 2003 - 04:51:08 CDT

news.omnitel.net wrote:
>
> Has some one tried to us SAP DB Stored procedures with syntax below?
>
>
>
> CREATE DBPROC <procedure_name> [(<formal_parameter>,..)]
> RETURNS CURSOR AS
> <routine>
>
>
>
> I have problems with it. It simply does not work. Has someone
> suggestions
> how to create working stored procedure returning cursor?
>
>
>
> Test environment:
>
> DBM 7.4.3.10
>
> SQL Studio 7.4
>
>
>
> test source:
> CREATE DBPROC test_proc (IN result INTEGER)
> RETURNS CURSOR AS
> $CURSOR = 'HOTEL_CURSOR';
> DECLARE :$CURSOR CURSOR FOR
> SELECT :result FROM DBA.DUAL;
>
>
>
> test rezults:
>
> call test_proc(1)
> "Statement successfully executed. No Result"
>
> expected rezults:
>
> One row in ouput

As written by Wolfgang:

With SQLStudio the correct handling of dbprocs returning cursors
WILL be available in the next version.

--> Please use newest JDBC or the like.

Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general