My Oracle Support Banner

Pro*C Mod (salmth) Is Failing In Production With Error -1036~ORA-01036: Illegal Variable Name/number (Doc ID 2965266.1)

Last updated on AUGUST 08, 2023

Applies to:

Oracle Retail Merchandising System - Version 13.1.9 and later
Information in this document applies to any platform.

Goal

In RMS 13.1.9

Pro*C module (salmth) is failing in production and have no sales reported....code got compiled using 12.2 version of the compiler and now this job keeps failing

Error:
-1036~ORA-01036: illegal variable name/number~STORED FUNCTION CALL FAILED: function=STKLEDGR_ACCTING_SQL.RETAIL_METHOD_CALC

 

Solution

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
Goal
Solution
References


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