Unable to Submit the Program in Real Mode when a Program View is Added as a Source Table Descriptor
Last updated on MARCH 08, 2017
Applies to:Oracle Life Sciences Data Hub - Version 126.96.36.199 and later
Information in this document applies to any platform.
On Oracle Life Sciences Data Hub (LSH) 188.8.131.52,
Users are noticing the following error message when submitting a PLSQL Program in Real mode:
o When a Program View is added as a Source TD to the program, users are not able to submit the Program in Real mode, even with the correct roles and privileges assigned.
o If you remove the Program View TD from the program, only then it can be submitted in Real mode without the aforementioned error message.
It is expected that users should be able to run the entire program with having to remove the Program View.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms