Hi,

i just created my first dbproc. It�s create-statement ist very simple:
create dbproc test RETURNS CURSOR AS
$CURSOR = 'Test_Cursor';
declare :$CURSOR cursor for
select * from "ROOT"."3_0_TEST";

Now I want to test the Proc in the SQL-Studio, but when I run the call-Statement like 
call test with commit i�ve get the answer that the statement is executed sucessfull 
without result. But in the table "3_0_TEST" are ten rows. Where ist my mistake?? 

Greetings and thanks,
Andreas
______________________________________________________________________________
UNICEF bittet um Spenden fur die Kinder im Irak! Hier online an
UNICEF spenden: https://spenden.web.de/unicef/special/?mc=021101

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to