LSH View Installation Is Failing With ORA-20200: '*** ERROR: Exception while trying to handle view programs'
(Doc ID 2551793.1)
Last updated on OCTOBER 04, 2019
Applies to:Oracle Life Sciences Data Hub - Version 22.214.171.124 and later
Information in this document applies to any platform.
The following error occurs when attempting to install a Program View:
The issue can be reproduced at will with the following steps:
1. Create a Table Instance TAB in a Work Area
2. Create a View Program in the same Work Area and add TAB as table descriptor
3. Add a source code that is bigger than 32K to the view program.
4. Install the View Program.
Program View with a source code bigger that 32K is created.
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