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
