My Oracle Support Banner

JTF_NOTES_B.NOTES_DETAIL 32K Character Limit (Doc ID 2615428.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.


The API JTF_NOTES_PUB.CREATE_NOTE is being used to create notes for attaching to Service Requests. In the API the notes detail column is of CLOB data type, but the api parameter P_NOTES_DETAIL is of VARCHAR2. Users are not able to create a note with size beyond 32767. Is it possible to insert data of greater length to the CLOB column?


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.