ORA-19270: XP0050 - treat failed - expected string got string

Cause : The type of the operand to the treat expression did not match the required type.

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

Fix the input operand to be of the correct type.

update : 23-07-2017
ORA-19270

ORA-19270 - XP0050 - treat failed - expected string got string
ORA-19270 - XP0050 - treat failed - expected string got string

  • ora-07502 : scgcmn: $enq unexpected return
  • ora-00126 : connection refused; invalid duplicity
  • ora-06572 : Function string has out arguments
  • ora-31411 : change set string is referenced by a change table
  • ora-01618 : redo thread string is not enabled - cannot mount
  • ora-31408 : invalid value specified for begin_scn or end_scn
  • ora-27465 : invalid value string for attribute string
  • ora-28182 : cannot acquire Kerberos service ticket for client
  • ora-14610 : Lob attributes not specified for lob column string for subpartition string
  • ora-22283 : filename contains characters that refer to parent directory
  • ora-29311 : export dump file was not generated by this database, string does not match
  • ora-28535 : invalid Heterogeneous Services context
  • ora-32060 : channel failure
  • ora-12518 : TNS:listener could not hand off client connection
  • ora-03264 : cannot drop offline datafile of locally managed tablespace
  • ora-19263 : XQ0043 - duplicate namespace prefix string
  • ora-27003 : cannot open file on device allocated with NOIO option
  • ora-31228 : DBMS_LDAP: invalid MOD_ARRAY
  • ora-12417 : database object "string" not found
  • ora-00964 : table name not in FROM list
  • ora-09966 : falure in translation while expanding ?/dbs/lk for lock file
  • ora-01347 : Supplemental log data no longer found
  • ora-14020 : this physical attribute may not be specified for a table partition
  • ora-14283 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-16514 : the request was not found
  • ora-38725 : specified name "string" does not match actual "string"
  • ora-13024 : polygon has less than three segments
  • ora-16248 : RFS connections not permitted during Terminal Apply
  • ora-26027 : unique index string.string partition string initially in unusable state
  • ora-39157 : error appending extension to file "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.