MQSeries.net :: View topic - Oracle error Invalid cursor state

HYY

Hi, I am digging my head on this problem. Any help and comments will be very much appreciated.

I have set up the ODBC link to access the database and followed manual for the DSN configuration. I am able to execute SQL statement using PASSTHRU. However, when I am trying to invoke stored proc using PASSTHRU statement I keep having the runtime error back :

Database error: SQL State'24000'; Native Error Code'0'; Error Text '[DataDirect][ODBC Oracle driver] Invalid cursor state'

ESQL code is:
SET OutputRoot.XML.GetReferenceData.Result.Data[] = PASSTHRU('{CALL SETAS_APP.SIMPLE1(?)}',OutputRoot.XML.GetReferenceData.EMPNO);

Oracle stored proc is:

( p1 IN INT ) IS
tmpVar NUMBER;
BEGIN
tmpVar := p1;
END simple1;

stored proc name: SIMPLE1
schema: SETAS_APP

The stored proc has been tested working fine using SQLPLUS.

WBIMB version : 5.0.1.4 (on WINDOW)
ODBC driver: MQSeries DataDirect 4.10 32 BIT Oracle 8
Oracle Database: Oracle 9

Any comments? Many thanks!!!

HYY