Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to store 30000 plus characters in a particular text field, which datatype should be use for it?

User_9URBTSep 21 2022 — edited Sep 21 2022

Here, I have a problem in which I want to store 30000 plus characters (paragraphs) in an individual field instance. Moreover, I tried the CLOB datatype for a column, but when I am crossing the characters storing up to 2900, it gives me an error: ORA-00972: the identifier is too long. So which datatype is best/suitable to store maximum characters or I would say that store 3, 2 paragraphs in a particular field single row. As a newbie, your meaningful response will be appreciable.

Thanks
This post has been answered by User_9URBT on Sep 21 2022
Jump to Answer

Comments

santiago_nc

I don't fix this yet.

santiago_nc

Any help?

Hi,

Why not use MDS? Why you've to re-create the VO just for changing it's UI hints and properties?

Check out this sample : http://andrejusb.blogspot.in/2014/04/mds-seeded-customization-approach-with.html

-Arun

santiago_nc

Hi,

I have to recreate the VO at runtime since I could change the query, add different LOV to an attribute at runtime, etc Really, the ViewObject created by jDveloper is a template which I could change at runtime with meta-data saved in DataBase.

Each application is a TaskFlow pageFragment based which is rendered as a Region. Then, It could show same application in two regions, showing different ViewObject Instances at runtime.

1 - 4

Post Details

Added on Sep 21 2022
#oracle, #sqlplus
5 comments
876 views