ORA-13635: The value provided for parameter string cannot be converted to a number.

Cause : A numeric parameter was incorrectly supplied in string form.

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

Retry by supplying valid numeric value.

update : 27-06-2017
ORA-13635

ORA-13635 - The value provided for parameter string cannot be converted to a number.
ORA-13635 - The value provided for parameter string cannot be converted to a number.

  • ora-14302 : only one list of added-LOB-storage-clauses can be specified in a statement
  • ora-13053 : maximum number of geometric elements in argument list exceeded
  • ora-16092 : dependent archive log destination is not active
  • ora-24057 : cannot define subscriber with rule for queue string
  • ora-16527 : unable to allocate SGA heap
  • ora-12649 : Unknown encryption or data integrity algorithm
  • ora-31028 : Resource metadata length string exceeded maximum length string
  • ora-30443 : definition for filter string's item string is invalid
  • ora-16823 : redo transport mode is incompatible for current operation
  • ora-30034 : Undo tablespace cannot be specified as temporary tablespace
  • ora-01516 : nonexistent log file, datafile, or tempfile "string"
  • ora-14074 : partition bound must collate higher than that of the last partition
  • ora-28344 : fails to decrypt data
  • ora-39114 : Dump files are not supported for network jobs.
  • ora-29542 : class string already defined by source string
  • ora-32820 : subscriber queue and exception queue must use same message system link
  • ora-04045 : errors during recompilation/revalidation of string.string
  • ora-16804 : one or more configuration properties in metadata have invalid values
  • ora-24004 : invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY
  • ora-13029 : Invalid SRID in the SDO_GEOMETRY object
  • ora-30566 : Index maintainence clause not allowed for this command
  • ora-30957 : cannot downgrade because there are XML indexes
  • ora-15070 : maximum number of files string exceeded in diskgroup "string"
  • ora-13870 : Database-wide SQL tracing is not enabled
  • ora-24415 : Missing or null username.
  • ora-23421 : job number string is not a job in the job queue
  • ora-27204 : skgfpqr: sbtpcqueryrestore returned error
  • ora-02043 : must end current transaction before executing string
  • ora-26010 : Column string in table string is NOT NULL and is not being loaded
  • ora-32739 : Hang analysis aborted due to failed heap re-grow
  • 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.