FRM 40735 with ORA-32767 On CLOB Table when Passing Parameter in Forms 11g (Doc ID 1485877.1)

Last updated on APRIL 18, 2016

Applies to:

Oracle Forms - Version 11.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

Steps to reproduce:

1.  declare a variable in a procedure as a clob_table

2.  fill the clob table with data

3. pass this variable to a database package for further processing.

4. These errors will occur ->: FRM-40735 and ORA-32767

 

The issue does not occur with Forms 10g

 

Example of procedure that reproduces the issue:

 

where Prc_create_list  is a DB stored procedure.

Changes

 Upgrade to 11g environment

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms