hi all!

I'm testing interbase 6 using gemini ODBC conectivity, and Visual C++. I use stored procedures, but when i call a specific non-return values stored procerdure, ODBC shows me an error: state: HY000, native =
-84, procedure xxxxx does not return any values. In fact, such procedure does not return any values, because i don't need it. So, why the error?


thanks


Aldemar

Hi Aldemar!

I don´t know exactly how things work out with ODBC connectivity, but at least I received exactly the same error message using Firebird server and .NET Data Provider.

My misktake was to invoke the stored procedure with the wrong method call. With .NET there´s a method called "ExecuteNonQuery" which should be the right one for this kind of stored procedures.

Maybe with ODBC it´s similar?

Best regards,
Mark.