My Oracle Support Banner

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: to - Release: 10.2 to 10.2
Microsoft Windows (32-bit)


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.


Upgraded from to or Oracle ODBC Driver.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.