('[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
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
]');
-- 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