Hi Marcin, > -----Original Message----- > From: Marcin P [mailto:[EMAIL PROTECTED]] > Sent: Donnerstag, 16. Januar 2003 13:15 > To: [EMAIL PROTECTED] > Subject: How to call SP returning resultset and out parameter > > > Hello, > I have created a sp like one below: > 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??
The combination of resultset and out parameter is not supported yet. Actually this in no bug inside of ODBC. DBProcs with resultsets can be used with ODBC. To decide whether a DBProc returns a resultset SQLNumResultCol () can be called after execution (SQLPrepare is not sufficient, of course). Regards Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin SAP DB is open source. Get it! www.sapdb.org _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
