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 : 19-08-2017

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

  • ora-02034 : speed bind not permitted
  • ora-25113 : GLOBAL may not be used with a bitmap index
  • ora-25287 : Invalid value string, string should be non-negative
  • ora-00297 : must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START
  • ora-26532 : replication parallel push simulated site failure
  • ora-24329 : invalid character set identifier
  • ora-27088 : unable to get file status
  • ora-13621 : The task_or object string is marked as a template and cannot perform the requested operation.
  • ora-29656 : Invalid option for USING
  • ora-33305 : (DBVALID06) Note: Record number was allocated but not used. This can result in wasted space. (PS number)
  • ora-31514 : change set string disabled due to capture error
  • ora-16660 : FSFO operation attempted in absence of a broker configuration
  • ora-06515 : PL/SQL: unhandled exception string
  • ora-02458 : HASHKEYS must be specified for a HASH CLUSTER
  • ora-32053 : operation not supported
  • ora-23448 : duplicate user parameter value
  • ora-06711 : TLI Driver: error on bind
  • ora-06801 : TLI Driver: listen for SPX server reconnect failed
  • ora-02760 : Client close of file failed.
  • ora-23467 : flavor lacks object "string"."string"
  • ora-32161 : Cannot perform piecewise fetch
  • ora-00289 : suggestion : string
  • ora-01724 : floating point precision is out of range (1 to 126)
  • ora-07744 : slemcl: invalid error message file handle
  • ora-02431 : cannot disable constraint (string) - no such constraint
  • ora-06528 : Error executing PL/SQL profiler
  • ora-38419 : invalid identifier in attribute : string
  • ora-38956 : Target platform string not cross platform compliant
  • ora-01943 : IDENTIFIED BY already specified
  • ora-16112 : log mining and apply stopping
  • 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.