I'm having some problems while saving data into Oracle database. I have posted the same question in the Oracle section too. I'm posting it here to get the Perl's experts' comments that if we can reslove this problem uisng Perl itself. Here is my question:
I'm getting error message "ORA-01401: Inserted value too large for column". In fact, the length of data which I'm trying to insert into table, is less than the column's width. Since the input is coming from a web page (from a Textarea field), it consists of multiple lines and thus has some carriage returns in it. I guess that's what is causing problem.
I'm using Perl and connecting to Oracle 8 using Microsoft ODBC Driver for Oracle.
Any suggestion/help will be highly appreciated.
Thanks in advance,