Forum Stats

  • 3,826,042 Users
  • 2,260,590 Discussions
  • 7,896,773 Comments

Discussions

Patch 26203132 didn't work PROC FAILS WITH ORA 1036 AT RUN TIME WHILE EXECUTING PLSQL WITH INDICATOR

User_ZJC9T
User_ZJC9T Member Posts: 4 Green Ribbon
edited Mar 30, 2021 7:32PM in General Database Discussions

Hi,

Patch 26203132 (PROC FAILS WITH ORA 1036 AT RUN TIME WHILE EXECUTING PLSQL WITH INDICATOR) is applied for 32 bit oracle client on app server by DBA(Oracle : Release 19.0.0.0.0 - Version 19.3.0.0.0). However, we are still getting the run time error when we call a stored procedure from the PLSQL block with indicator variables. Can someone please let me know if there are any pointers for us (application/dev team) or DBA to check after the patch is installed?

As the patch is specific to precompiler libraries (/opt/oracle/product/19.3.0.0/precomp/lib) I assume that it's enough if it's applied on the ORACLE_HOME client on the application server where we make(build) the PRO*C files.

Tagged: