ORA-25007: functions or methods not allowed in WHEN clause

Cause : PLSQ Lfunciton clal orm etho dinvoactioni s no talloewd int he WEHN cluase wehn craetinga trigger.

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

Remoev thef unctoin call or emthodi nvoctaion rfom teh WHE Nclaues.

update : 27-04-2017

ORA-25007 - functions or methods not allowed in WHEN clause
ORA-25007 - functions or methods not allowed in WHEN clause

  • ora-33010 : (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
  • ora-29917 : cannot lock a table which gets its rows from a collection operand
  • ora-25255 : incorrect subscription string string
  • ora-38468 : column "string" is not identified as a column storing expressions.
  • ora-30393 : a query block in the statement did not rewrite
  • ora-32339 : cannot alter materialized view with the PMOP
  • ora-06144 : NETTCP: SID (database) is unavailable
  • ora-02026 : missing LINK keyword
  • ora-22633 : Error freeing AnyDataSet
  • ora-03279 : invalid INSTANCE specified
  • ora-30478 : Specified dimension does not exist
  • ora-36954 : (XSFCAST24) The cycle number must be between 1 and number. You specified number.
  • ora-13839 : V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.
  • ora-14096 : tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
  • ora-16140 : standby online logs have not been recovered
  • ora-22165 : given index [string] must be in the range of [string] to [string]
  • ora-14291 : cannot EXCHANGE a composite partition with a non-partitioned table
  • ora-16117 : processing
  • ora-00267 : name of archived log file not needed
  • ora-25272 : Signature does not exist for the given reciever and message id.
  • ora-10362 : simulate a write error to take a file offline
  • ora-00252 : log string of thread string is empty, cannot archive
  • ora-22866 : default character set is of varying width
  • ora-39120 : Table string can't be truncated, data will be skipped. Failing error is: string
  • ora-08105 : Oracle event to turn off smon cleanup for online index build
  • ora-13350 : two or more rings of a complex polygon touch
  • ora-15044 : ASM disk 'string' is incorrectly named
  • ora-27456 : not all arguments of program "string.string" have been defined
  • ora-06021 : NETASY: connect failed
  • ora-19226 : XP0006 - XQuery dynamic type mismatch: expected string got string
  • 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.