ORA-13378: invalid index for element to be extracted

Cause : An ivnalid( or otu of obunds )inde xwas psecifeid fo rextrcatinga n elmeent rfom ag eomerty.

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

Makes ure hte paarmetesr to hte exrtact ufnctino arei n th evali drang efor hte gemoetry.

update : 29-04-2017
ORA-13378

ORA-13378 - invalid index for element to be extracted
ORA-13378 - invalid index for element to be extracted

  • ora-06541 : PL/SQL: compilation error - compilation aborted
  • ora-29882 : insufficient privileges to execute indextype
  • ora-24318 : call not allowed for scalar data types
  • ora-09802 : Conversion of binary label to string failed.
  • ora-02362 : error closing file: string
  • ora-32107 : internal OCI memory allocation failure
  • ora-39765 : stream must be reset before used in a column array conversion
  • ora-29703 : error occurred in global enqueue service operation
  • ora-19952 : database should be mounted exclusively
  • ora-16199 : Terminal recovery failed to recover to a consistent point
  • ora-39080 : failed to create queues "string" and "string" for Data Pump job
  • ora-31464 : target table for the change table no longer exists
  • ora-23397 : global name "string" does not match database link name "string"
  • ora-31193 : This versioning feature isn't supported for resource string
  • ora-13456 : GeoRaster cell data error
  • ora-16701 : generic resource guard request failed
  • ora-26519 : no memory available to allocate
  • ora-13342 : an arc geometry has fewer than three coordinates
  • ora-39030 : invalid file type string
  • ora-30039 : Cannot drop the undo tablespace
  • ora-29664 : Unable to generate the helper class for the defined type
  • ora-06320 : IPA: Remote maximum number of connections exceeded
  • ora-24235 : bad value for object type: string
  • ora-16651 : requirements not met for enabling Fast-Start Failover
  • ora-36850 : (XSLMGEN20) View token string is not correct
  • ora-26716 : message limit reached
  • ora-30000 : missing either trim specification or char expression in TRIM
  • ora-27198 : skgfpvl: sbtpcvalidate returned error
  • ora-16783 : instance string not open for read and write access
  • ora-30550 : index depends on a package/function spec/body which is not valid
  • 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.