Stored Procedures via ODBC

From: Ronnie Brown <Ronnie.Brown_at_msi-solutions.com>
Date: Tue, 24 Aug 1999 20:28:27 GMT
Message-ID: <LfDw3.382$%c.31194_at_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 - 22:28:27 CEST