Stored Procedures via ODBC

From: Ronnie Brown <Ronnie.Brown_at_msi-solutions.com>
Date: Tue, 24 Aug 1999 20:21:45 GMT
Message-ID: <t9Dw3.378$%c.31086@monger.newsread.com>

ODBC calls SQLExecDirect or SQLExecute hangs when calling a stored procedure as follows:

SQLExecDirect( hstmt, "{ CALL SYSTEM.get_date ( ? ) }", SQL_NTS );

However, I have no problem if the scheama name is not included such as:

SQLExecDirect( hstmt, "{ CALL get_date ( ? ) }", SQL_NTS );

This happens when using the Oracle ODBC driver version 8.0.4.4.0.

Does anyone know if this is a known bug or if there is a work around ? Received on Tue Aug 24 1999 - 15:21:45 CDT