FRM 40735 with ORA-32767 On CLOB Table when Passing Parameter in Forms 11g
Last updated on APRIL 18, 2016
Applies to:Oracle Forms - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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.
Upgrade to 11g environment
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