Re: [PL/SQL NEWBIE]Detect Varchar2 field length

Catherine wrote:
> Perhaps a function that will check
> LENGTH(whatever) <= DATA_LENGTH
> where DATA_LENGTH is queried from ALL_TAB_COLUMNS?
> Good luck!

Catherine,

thanks for taking time to reply.

I always tend to forget the existence of those tables, so your tip was really helpful.

I only had one minor issue with CLOBs (the reported length is 4000) but I worked around it.

Regards.

Alessandro Received on Fri Nov 26 2004 - 04:41:59 CST