My Oracle Support Banner

Getting ORA-01461 while INSERT INTO WWV_THINGS (Doc ID 558671.1)

Last updated on APRIL 06, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

-- Problem Statement:
A batch job is failing with ORA-01461.

ksedmp: internal or fatal error
ORA-01461: can bind a LONG value only for insert into a LONG column
Current SQL statement for this session:
INSERT INTO WWV_THINGS( ID, SITEID, GUID, PRIMARYTHINGID, PARENTID, CORNERID, TOPICID, TOPICSITEID, SUBTYPE, SUBTYPESITEID, NAME, TITLE, AUTHOR, DESCRIPTION, IMAGE, LANGUAGE, URL, FILENAME, TEXTID, FULLSCREEN, NEWLINE, EXPIREDATE, ACTIVE, ISCURRENTVERSION, KEYWORDS, CORNERLINKID, ITEMTYPE, CHECKABLE, INPLACE, REGIONID, CTXTXT, CORNERLINKSITEID, CREATOR, PLSQL_EXECUTOR, CREATEDATE, PUBLISHDATE, EXPIREMODE, EXPIRENUMBER, IMAGE_ALIGN, VERSION, PORTLET_INST_GUID, VALUE, VALUE2, VALUE_NUMBER, VALUE2_NUMBER, VALUE3_NUMBER, UPDATEDATE, UPDATOR, CHECKEDOUT, CHECKER, SECURITY, PLACEHOLDER_CONTENT_ITEM_GUID, ITEM_PAGE_ID, ITEM_PAGE_SITE_ID, ITEM_PAGE_TABSTRING, INHERIT_ITEM_PAGE, VALUE4_NUMBER ) VALUES( :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , DECODE( :B35 , NULL, 0, 1 ), :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , 1, :B25 , :B11 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , SYSDATE, :B11 , :B10 , :B9 , NVL(:B8 , :B7 ), :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) RETURNING CREATEDATE INTO :O0
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x57f741e8      1964  package body TEST1.WWV_THINGSAVE
0x57f741e8      3975  package body TEST1.WWV_THINGSAVE
0x58e4765c      1516  package body TEST1.WWSBR_API
0x58e4765c      1674  package body TEST1.WWSBR_API
0x555eb87c       243  package body TEST2.ZBBR0001
0x555eb87c       311  package body TEST2.ZBBR0001
0x555eb87c      1144  package body TEST2.ZBBR0001
0x30ba269c         1  anonymous block


 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.