ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

Cause : A Bind value of length potentially > 4000 bytes follows binding for LOB or LONG.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Re-order the binds so that the LONG bind or LOB binds are all at the end of the bind list.

update : 28-05-2017

ORA-24816 - Expanded non LONG bind data supplied after actual LONG or LOB column
ORA-24816 - Expanded non LONG bind data supplied after actual LONG or LOB column

  • ora-39705 : component 'string' not found in registry
  • ora-14453 : attempt to use a LOB of a temporary table, whose data has alreadybeen purged
  • ora-31161 : element or attribute "string" cannot be stored out of line
  • ora-01162 : block size string in file header does not match configured block sizes
  • ora-09916 : Required password was not specified.
  • ora-31469 : cannot enable Change Data Capture for change set string
  • ora-38731 : Expected version string does not match string in log header.
  • ora-07305 : ksmcsg: illegal database buffer size.
  • ora-00216 : control file could not be resized for migration from 8.0.2
  • ora-38481 : ADT "string" is used for a dependent object.
  • ora-01985 : cannot create user as LICENSE_MAX_USERS parameter exceeded
  • ora-37179 : expected at least one column for dimension string, got string
  • ora-29875 : failed in the execution of the ODCIINDEXINSERT routine
  • ora-13048 : recursive SQL fetch error
  • ora-29809 : cannot drop an operator with dependent objects
  • ora-01220 : file based sort illegal before database is open
  • ora-29555 : Java source, class or resource is not allowed here
  • ora-12204 : TNS:received data refused from an application
  • ora-13368 : simple polygon type has more than one exterior ring
  • ora-01494 : invalid SIZE specified
  • ora-31081 : name not specified for global declaration
  • ora-01241 : an external cache has died
  • ora-28238 : no seed provided
  • ora-07647 : sszfck: $OPEN failure
  • ora-06575 : Package or function string is in an invalid state
  • ora-06616 : LU6.2 Driver: Attach to LU failed
  • ora-30740 : cannot grant UNDER privilege on this object
  • ora-16031 : parameter string destination string exceeds string character limit
  • ora-12635 : No authentication adapters available
  • ora-14324 : values being added already exist in DEFAULT partition
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.