ORA-01036 When Calling A Stored Function Using SCHEMA.FUNCTION Name (Doc ID 396549.1)

Last updated on JULY 05, 2017

Applies to:

Oracle ODBC Driver - Version: 10.2.0.1 to 10.2.0.3 - Release: 10.2 to 10.2
Microsoft Windows (32-bit)

Symptoms

When executing a c++ application that calls a stored function using the schema.function_name results in the following error:
DIAG [S1000] [Oracle][ODBC][Ora]ORA-1036: illegal variable name/number (1036)

The code being used is the following:
SQLExecDirect(ghStatement, (SQLCHAR*)"{? = call scott.TESTPROC()}" , SQL_NTS);

The same code worked with previous versions of the Oracle ODBC driver.
After upgrading to 10.2 the error occurs.

Changes

Upgraded from 9.2.0.3.0 to 10.2.0.1 or 10.2.0.2.0 Oracle ODBC Driver.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms