Thank You very much for Your interests, I'm waiting for test results, Marcin Pytel Talex S.A.
"Stausberg, Markus" <[EMAIL PROTECTED]> has written 17C3801C2DE6D311A35200508B6FF14B0261527B@dewdfx2b">news:17C3801C2DE6D311A35200508B6FF14B0261527B@dewdfx2b... > hello Marcin, > > you wrote : > > CREATE DB_PROC SP_EXAMPLE(OUT STATUS INTEGER) RETURNS CURSOR AS SET > > STATUS=10; DECLARE :$CURSOR CURSOR FOR SELECT * FROM > > TEST_USER.TBL_EXAMPLE; > > > > It was compiled ok, but ... > > How to execute it from SQL Studio? > > I've also tried to execute it from VB 6 simple application, > > but it returns General error;-4024. > > The same example works fine with Microsoft SQL Server 2k. > > I have impression that there is a bug in ODBC driver, isn't it?? > > currently SQL St. doesn't handle dbprocs which return cursors. > (and Studio's (transparently installed) ODBC driver can't handle it as well.) > > we will test if the current sapdb official ODBC driver (which comes in a > separate download) can actually handle this. (we believe it should) > > > regards, > > Markus Stausberg > SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
