java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column


Solutions on the web

Solution icon of oraclecommunity
via Oracle Community by User_OIM, 1 year ago
ORA-01461: can bind a LONG value only for insert into a LONG column

Solution icon of stackoverflow
via Stack Overflow by Eugen
, 1 year ago
ORA-01461: can bind a LONG value only for insert into a LONG column

Solution icon of oraclecommunity
ORA-01461: can bind a LONG value only for insert into a LONG column

Solution icon of stackoverflow
via Stack Overflow by Unknown author, 1 year ago
ORA-01461: can bind a LONG value only for insert into a LONG column Complete error stack (or at least the part that doesn't refer to my code) follows: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

Solution icon of sourceforge
ORA-00972: identifier is too long ; State=42000; ErrorCode=972

Solution icon of googlegroups
via Google Groups by Bing Qiu, 4 months ago
ORA-01400: cannot insert NULL into ("DOTCMSAUTH"."CONTENTPAGES_TEMP_8042DE49013"."LIVE_INODE")

Solution icon of github
ORA-01400: cannot insert NULL into ("DOTCMSMASTER"."CLUSTER_SERVER"."IP_ADDRESS")

Solution icon of googlegroups
via Google Groups by Gynnad, 3 months ago
ORA-01400: cannot insert NULL into ("DOTCMS"."PLUGIN_PROPERTY"."ORIGINAL_VALUE")

Solution icon of jasig
via Apereo Issues by Bill Brown, 1 year ago
ORA-01400: cannot insert NULL into ("UNICON"."UP_LAYOUT_PARAM"."STRUCT_PARM_VAL")

Solution icon of googlegroups
via Google Groups by Dmitry, 1 month ago
ORA-01400: cannot insert NULL into ("EXIMGATE"."OUT_MESSAGES"."ADDRESS")

Stack trace

java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
	at com.thortech.xl.scheduler.core.quartz.QuartzWrapper.updateStatusToError(Unknown Source)
	at com.thortech.xl.scheduler.core.quartz.QuartzWrapper.access$600(Unknown Source)
	at com.thortech.xl.scheduler.core.quartz.QuartzWrapper$TaskExecutionAction.run(Unknown Source)
	at Thor.API.Security.LoginHandler.jbossLoginSession.runAs(Unknown Source)
	at com.thortech.xl.scheduler.core.quartz.QuartzWrapper.execute(Unknown Source)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 4 months ago
Samebug visitor profile picture
Unknown user
Once, 4 months ago
Samebug visitor profile picture
Unknown user
Once, 4 months ago
Samebug visitor profile picture
Unknown user
Once, 4 months ago
Samebug visitor profile picture
Unknown user
Once, 4 months ago
369 more bugmates