PL/SQL (MOSC)

MOSC Banner

insert over one CLOB column error ORA-01461

edited Feb 26, 2015 10:04AM in PL/SQL (MOSC) 2 commentsAnswered

inseHi guys

I'm getting this error message when I'm doing a inert thrh ojdbc 6 driver

org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO TSYUSER.BBG_DETALLE_ENVIOS (ID_DETALLE_ENVIO,PORTAFOLIO,TIPO_MOV,SECURITY,FECHA_OPERACION,DET_ERROR,COMENTARIO,FEC_ENVIO,HORA_ENVIO,INFO_ENVIO,RESULTADO_ENVIO,FEC_ACT,HORA_ACT,TRADER,TICKET_NUMBER) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; SQL state [72000]; error code [1461]; ORA-01461:

Note the column its CLOB; it shouldn't have any issue to do insert bigger than 4K

Any idea on where it could be the issue

JEsus

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center