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 : 28-04-2017

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-39087 : directory name string is invalid
  • ora-15041 : diskgroup space exhausted
  • ora-07549 : sftopn: $OPEN failure
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-21779 : duration not active
  • ora-32162 : Read/Write SQL method not registered
  • ora-31422 : owner schema string does not exist
  • ora-16650 : command incompatible when Fast-Start Failover is enabled
  • ora-07223 : slspool: fork error, unable to spawn spool process.
  • ora-24019 : identifier for string too long, should not be greater than string characters
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • ora-29338 : datafile string is in an undesired state (string, string)
  • ora-16186 : Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier
  • ora-24504 : data length larger than expected
  • ora-13339 : LRS polygon clipping across multiple rings
  • ora-14315 : cannot merge a partition with itself
  • ora-03007 : obsolete feature
  • ora-07843 : sllfcl: LIB$FREE_VM failure
  • ora-28347 : encryption properties mismatch
  • ora-13207 : incorrect use of the [string] operator
  • ora-12162 : TNS:net service name is incorrectly specified
  • ora-30198 : reserved for future use
  • ora-25135 : cannot use the SINGLE TABLE option
  • ora-22893 : constraint can be specified only for REF columns
  • ora-07602 : spgto: $GETJPIW failure
  • ora-02351 : internal error: string
  • ora-14169 : invalid ALTER TABLE MODIFY SUBPARTITION option
  • ora-37044 : (XSACQUIRE_OLDGEN) Cannot acquire object workspace object without resync.
  • ora-24292 : no more tables permitted in this sorted hash cluster
  • ora-00258 : manual archiving in NOARCHIVELOG mode must identify log
  • 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.