ORA-01036 When Calling A Stored Function Using SCHEMA.FUNCTION Name
(Doc ID 396549.1)
Last updated on OCTOBER 07, 2022
Applies to:
Oracle ODBC Driver - Version 10.2.0.1 to 10.2.0.3 [Release 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 <SCHEMANAME>.<FUNCTIONNAME>()}" , 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
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |