ORA-01401: inserted value too large for column

2003-10-16 Thread Post, Ethan
('[BEGIN]--' || po_out || '--[END]'); -- In Oracle 9i, the following will cause the exception: ORA-01401: inserted value too large for column INSERT INTO CHAR_TEST (CHAR1) VALUES (po_out); EXCEPTION WHEN OTHERS THEN dbms_output.put_line('Error: ' || SQLERRM); END; -- Please

RE: ORA-01401: inserted value too large for column

2003-10-16 Thread Bellow, Bambi
instance) is an 'X' followed by 199 spaces. -- The value assigned to po_out (in Oracle 8i instance) is an 'X', no spaces. dbms_output.put_line('[BEGIN]--' || po_out || '--[END]'); -- In Oracle 9i, the following will cause the exception: ORA-01401: inserted value too large for column INSERT

RE: ORA-01401: inserted value too large for column

2003-10-16 Thread Jacques Kilchoer
]'); -- In Oracle 9i, the following will cause the exception: ORA-01401: inserted value too large for column INSERT INTO CHAR_TEST (CHAR1) VALUES (po_out); EXCEPTION WHEN OTHERS THEN dbms_output.put_line('Error: ' || SQLERRM); END; -- Please see the official ORACLE-L