ORA-25008: no implicit conversion to LOB datatype in instead-of trigger

Cause : Wheni nseritng o rupdaitng av iew suing nistea-dof tirgger ,the enw vaule fo ra LO Bviewc olum nis o fa differen tdataytpe.

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

Specfiied aLOB avlue sa then ew vlaue fro theL OB veiw coulmn.

update : 23-04-2017

ORA-25008 - no implicit conversion to LOB datatype in instead-of trigger
ORA-25008 - no implicit conversion to LOB datatype in instead-of trigger

  • ora-36831 : (XSLMGEN01) View token cannot be NA
  • ora-29356 : These parameters can be specified only for directives that refer to consumer groups
  • ora-36836 : (XSLMGEN06) Dimension string.string!string hierarchy string level string is missing a PHYSICALNAME property value
  • ora-25332 : Invalid release value string for queue table compatible parameter
  • ora-13865 : Module name must be specified
  • ora-07594 : spiip: $GETJPIW failure
  • ora-33308 : (DBVALID04) SEVERE ERROR: Record number used but not allocated
  • ora-19931 : file string has invalid creation SCN string
  • ora-14609 : Tablespace was not specified for the previous lob segments of column string in template but is specified for string
  • ora-37003 : (AWLISTALL01) number readers
  • ora-27024 : skgfqsbi: sbtinit2 returned error
  • ora-19682 : file string not in block media recovery context
  • ora-09754 : sppst: invalid process number passed to sppst.
  • ora-29846 : cannot create a local domain index on a string partitioned table
  • ora-00315 : log string of thread string, wrong thread # string in header
  • ora-13146 : could not find table substitution variable string
  • ora-14119 : specified partition bound is too long
  • ora-26060 : Can not convert type identifier for column string
  • ora-13456 : GeoRaster cell data error
  • ora-24141 : rule set string.string does not exist
  • ora-34514 : (MXOPERR) You cannot string string data in the expression that begins with 'string'.
  • ora-13441 : GeoRaster metadata SRS error
  • ora-31518 : change column string already exists in CDC change table string.string
  • ora-01125 : cannot disable media recovery - file string has online backup set
  • ora-00306 : limit of string instances in this database
  • ora-29320 : datafile header error
  • ora-00983 : cannot audit or noaudit SYS user actions
  • ora-39000 : bad dump file specification
  • ora-15023 : reached maximum allowable number of disks string
  • ora-25533 : FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified
  • 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.