Are there any field limitations on Oracle Forms 5?

[jeannie322]

Hey I have created my table with a LONG datatype. In the form it will only let me put a 400000 char limit on the field size before it starts erroring out.

If I make the char field more than 400000, when I do a query it says "query caused no records to be retrieved", when I change it back to 400000, it pulls in all my records.

Any ideas? the users want to be able to paste/type as much info in the field as possible, so I made the field a long datatype in the database.. should I have not done this?

Any ideas? comments?

Thanks in advance

 

[jeannie322]

No need to respond I have figured this one out..
thanks