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 : 25-04-2017

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

  • ora-02487 : Error in converting trace data
  • ora-38499 : expression set already configured for stored/indexed attributes
  • ora-23621 : Operation corresponding to script string is in progress.
  • ora-30021 : Operation not allowed on undo tablespace
  • ora-06315 : IPA: Invalid connect string
  • ora-19246 : XQ0026 - validation failed - element string not found in in-scope element declarations
  • ora-01633 : Real Application Clusters Option needed for this operation
  • ora-10657 : Lob column to be shrunk does not exist
  • ora-02492 : missing required file block increment size in NEXT clause
  • ora-00956 : missing or invalid auditing option
  • ora-00258 : manual archiving in NOARCHIVELOG mode must identify log
  • ora-21702 : object is not instantiated or has been de-instantiated in cache
  • ora-30118 : syntax error at 'string' at the end of input
  • ora-36268 : (XSCGMDLAGG01) 'string' is not a valid dimension value.
  • ora-16224 : Database Guard is enabled
  • ora-32133 : Cannot get stream from LOB/FILE
  • ora-21526 : initialization failed
  • ora-30347 : a table name is required to qualify the column specification
  • ora-14049 : invalid ALTER TABLE MODIFY PARTITION option
  • ora-36718 : (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.
  • ora-38454 : attribute set not defined for the column being indexed
  • ora-28002 : the password will expire within string days
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-13228 : spatial index create failed due to invalid type
  • ora-31520 : CDC subscription string already subscribes to publication ID string
  • ora-16192 : Primary and standby network integrity mismatch
  • ora-24909 : call in progress. Current operation cancelled
  • ora-13904 : The file has been dropped and recreated during the procedure call.
  • ora-31671 : Worker process string had an unhandled exception.
  • ora-22908 : reference to NULL table value
  • 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.