My Oracle Support Banner

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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.