ORA-19999: skip_row procedure was called

Cause : The skip_row procedure was called which raises this error

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

Skip_row should only be called within a trigger or a procedure called by a trigger.

update : 26-05-2017
ORA-19999

ORA-19999 - skip_row procedure was called
ORA-19999 - skip_row procedure was called

  • ora-14055 : keyword REBUILD in ALTER INDEX REBUILD must immediately follow
  • ora-08207 : ora_addr: cannot open address file
  • ora-15128 : ASM file name 'string' exceeds maximum length string
  • ora-02074 : cannot string in a distributed transaction
  • ora-00334 : archived log: 'string'
  • ora-22340 : cannot string type "string"."string". Dependent tables must be upgraded to latest version
  • ora-06031 : NETDNT: connect failed, unrecognized object name
  • ora-12659 : Error received from other process
  • ora-16749 : resource guard encountered errors in switchover to logical primary database
  • ora-31038 : Invalid string value: "string"
  • ora-36978 : (XSRELGID01) workspace object must be a self-relation.
  • ora-02177 : Missing required group number
  • ora-18015 : invalid source outline signature
  • ora-19642 : start SCN of incremental backup is string
  • ora-38311 : cannot purge objects owned by other users
  • ora-19276 : XP0005 - XPath step specifies an invalid element/attribute name: (string)
  • ora-30565 : Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified
  • ora-24274 : no row exists in the string table for these parameters
  • ora-32056 : invalid number of extents
  • ora-26056 : Requested direct path operation on a view is not supported.
  • ora-30134 : reserved for future use
  • ora-22928 : invalid privilege on directories
  • ora-08340 : This command not allowed on nCUBE, only one thread is ever used.
  • ora-13278 : failure to convert SRID to native format
  • ora-29970 : Specified registration id does not exist
  • ora-06925 : CMX: disconnect during connect request
  • ora-22280 : no more buffers available for operation
  • ora-32626 : illegal bounds or increment in MODEL FOR loop
  • ora-26693 : STREAMS string process dropped successfully, but error occurred while dropping rule set string
  • ora-29847 : cannot create a local domain index on a partitioned index-organized table
  • 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.