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 : 27-05-2017
ORA-19270

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

  • ora-08467 : error converting Oracle number to string
  • ora-30766 : cannot modify scope for a REF column with a REFERENCES constraint
  • ora-23357 : the propagator does not exist
  • ora-23448 : duplicate user parameter value
  • ora-29310 : database is not open, or opened as a clone
  • ora-14608 : Tablespace was specified for the previous lob segments of column string in template but is not specified for string
  • ora-36261 : (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.
  • ora-19956 : database should have no offline immediate datafiles
  • ora-06548 : no more rows needed
  • ora-00101 : invalid specification for system parameter DISPATCHERS
  • ora-06792 : TLI Driver: server cannot exec oracle
  • ora-03200 : the segment type specification is invalid
  • ora-39129 : Object type string not imported. Name conflicts with the master table
  • ora-16520 : unable to allocate resource id
  • ora-27513 : parameter string contains invalid value string
  • ora-01482 : unsupported character set
  • ora-30366 : child JOIN KEY columns not in same relation as child level
  • ora-22803 : object type contains zero attributes
  • ora-01156 : recovery in progress may need access to files
  • ora-14406 : updated partition key is beyond highest legal partition key
  • ora-39167 : Tablespace string was not found.
  • ora-27457 : argument string of job "string.string" has no value
  • ora-22342 : dependent VARRAY column exceeds the maximum inline column size
  • ora-03234 : unable to extend index string.string subpartition string by string in tablespace string
  • ora-07227 : rtneco: unable to set noecho mode.
  • ora-12611 : TNS:operation is not portable
  • ora-39142 : incompatible version number string in dump file "string"
  • ora-28042 : Server authentication failed
  • ora-27008 : function called with invalid file structure
  • ora-01311 : Illegal invocation of the mine_value function
  • 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.