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-09-2017

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

  • ora-27490 : cannot open disabled window "string.string"
  • ora-31438 : duplicate change table string
  • ora-01247 : database recovery through TSPITR of tablespace string
  • ora-01595 : error freeing extent (string) of rollback segment (string))
  • ora-34279 : (MXDCL37) CONCAT can only be used when defining a DIMENSION.
  • ora-26671 : maximum number of STREAMS processes exceeded
  • ora-31451 : invalid value string for capture_values, expecting: OLD, NEW, or BOTH
  • ora-31638 : cannot attach to job string for user string
  • ora-25402 : transaction must roll back
  • ora-12844 : cluster reconfiguration in progress
  • ora-19251 : XQ0031 - unsupported query version
  • ora-01540 : tablespace 'string' is not offline
  • ora-24155 : rule string.string not in rule set string.string
  • ora-12842 : Cursor invalidated during parallel execution
  • ora-32028 : Syslog facility or level not recognized
  • ora-24077 : cannot create propagation schedule for EXCEPTION queue string.string
  • ora-22297 : warning: Open LOBs exist at transaction commit time
  • ora-32104 : cannot retrieve OCI error message
  • ora-24903 : invalid namespace attribute passed into OCI call
  • ora-22855 : optional name for LOB storage segment incorrectly specified
  • ora-09710 : soarcv: buffer overflow.
  • ora-13232 : failed to allocate memory during R-tree creation
  • ora-28333 : column is not encrypted
  • ora-24014 : invalid value string, RETENTION_TIME should be FOREVER or non-negative
  • ora-01487 : packed decimal number too large for supplied buffer
  • ora-27207 : syntax error in device PARMS - parentheses mismatch or missing
  • ora-09815 : File name buffer overflow
  • ora-30390 : the source statement is not equivalent to the destination statement
  • ora-06413 : Connection not open.
  • ora-25112 : maximum number of BITMAP index columns is 30
  • 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.