Calls to "stproc" Built-in Fails with Error 201 in Version 11G (11.1)
Calls to "stproc" Built-in Fails with Error 201 in Version 11G (11.1)
Titleimage
Posted by Patrick Hamou on 2016:04:19 16:25:11
Introduction
APPLIES TO:
Oracle Reports Developer - Version: 11.1 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms
While upgrading Forms/Reports applications from older versions to version 11g (11.1), the calls to "stproc" are failing with following error :
Error 201 at line XX, column YY
identifier 'STPROC.INIT' must be declared
Error 0 at line XX, column YY
Statement ignored
Cause
The "stproc" built-in is used to call "Stored Procedures" from old versions of Forms/Reports. This built-in is reserved for backward compatibility until version 10gR2 (10.1.2) although it was deprecated long time ago, and is obsoleted in version 11g (11.1) and upwards.
For some time, stored procedures can be invoked directly, just like calling any local program unit by name. The recommended solution is to change the "stproc" calls to direct calls.
Solution
Call the stored procedures just like calling any local procedure. That is, by name directly without using any wrapper package in between.
Posted by Patrick Hamou on 2016:04:19 16:25:11