TRUNCATE on INSERT (ORACLE)

I think I know the answer, but I'll take a shot in the dark anyway...

There's no jdbc (or database) option for statement/connection/database/resultset whereas one can tell the database "if this string doesn't fit, truncate it", is there???

ie in ORACLE, how can I get this to work without altering the table or making the string shorter?

CREATE TABLE YYY ( FOO VARCHAR2(10)); INSERT INTO YYY VALUES('abcdefghijlkmnopqrstuvwxyz');

any help appreciated...

thx Received on Sat Aug 12 2000 - 00:00:00 CDT