Fully qualified proc names
Date: Tue, 23 Feb 2021 20:36:41 +0000
Message-ID: <DM6PR12MB2956EED24036B2AEA0D4CAA4DE809_at_DM6PR12MB2956.namprd12.prod.outlook.com>
Hello -
I have a weird situation going on and wondering if anyone else has experienced this and what is the solution.
I am running Oracle 12.1.0.2 on Linux 6. I have an app that passes data to Oracle and Oracle processes it and sends back a response - which happens to be an array.
This app has been running fine for years. Minimal changes. Starting last week, one of the main procedures has stopped working with this error:
"Package: F_CEUS_BLACK_BOX -- ErrorMessage: ORA-06550: line 1, column 12:
PLS-00302: component 'PKG_BLACK_BOX_CDR_STAT_CONTROL' must be declared
ORA-06550: line 1, column 7:
We have tried this on my Dev and my Test env. Those 2 env seem to be working fine with the schema name included in the name.....just my production is having this issue. I am at a loss about what is going on!
Has anyone else seen this?? If so, how did you fix it??
LeRoy
PL/SQL: Statement ignored"
[UW System Logo]
[All In Wisconsin]
[https://www.wisconsin.edu/uwsa/digital-communication/wp-content/uploads/sites/68/2019/04/twitter-sm.png]<https://twitter.com/uwsystem>
[https://www.wisconsin.edu/uwsa/digital-communication/wp-content/uploads/sites/68/2019/04/FB-sm.png]<https://www.facebook.com/uwsystem>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 23 2021 - 21:36:41 CET
(image/jpeg attachment: image001.jpg)