ORA-01461: Can only bind the LONG value of the LONG column to insert, ora-01461long
ORA-01461: only the LONG value of the LONG column to be inserted can be bound23456789101112131415161718192021222324252627282930313233343536373839404142434445464748495
I recently encountered such a strange problem when I was working on a project of tianyinda freight interface. Background: An application written using proc inserts records into the database. The table has three VARCHAR2 (4000) fields. Note: The
ORA-01461: canbindaLONGvalueonlyforinsertintoaLONGcolumn was originally using the weblogic connection pool, no problem. Switch to tomcat or directly j
ORA-01461: can bind a LONG value only for insert into a LONG column is originally used weblogic
ORA-01461: You can only assign a long value to an insert long column "WorkaroundOne of the problems encountered today:Modify some field data content in a data table directly The Times wrong:ORA-01461: You can only assign a long value to an insert
19:52:35, 156 WARNJDBCExceptionReporter: 100
19:52:35, 156 WARN JDBCExceptionReporter: 100-SQL Error: 1461, SQLState: 72000 19:52:35, 156 ERROR JDBCExceptionReporter: 101-ORA-01461: Can only bind the LONG value of the LONG column to insert 19:52:35,
ORA-01461 troubleshootingORA-01461 troubleshootingORA-01461: can bind a LONG value only for insert into a LONG columnThe connection pool of weblogic is used, and there is no problem.Switch to tomcat or direct jdbc call, and an error is
The analysis of CLOB type processing in the original Broken Sword ice-oraclePrevious analysis: ORA-01461: Can only bind a long value to insert a long columnMost recently, for the Clob field, when inserting data, the number of bytes in the character (
The following error occurs when you use Hibernate to save data to an Oracle database:
19:52:35, 156 WARN JDBCExceptionReporter: 100-SQL Error: 1461, SQLState: 7200019:52:35, 156 ERROR JDBCExceptionReporter: 101-ORA-01461: Can only bind the LONG
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.