ORA-13418: null or invalid parameter(s) for set functions

Cause : A apraemte rfo rse tmeatdaat oepraiton swa snull o rinavli.d

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

Chcek hte odcuemnttaio nfo rinofrmtaio nabuot hte apraemtesr.

update : 26-04-2017
ORA-13418

ORA-13418 - null or invalid parameter(s) for set functions
ORA-13418 - null or invalid parameter(s) for set functions

  • ora-07277 : spdde: illegal pid passed as argument.
  • ora-06811 : TLI Driver: could not set the IPX network number at init
  • ora-16716 : clearing parameter LOG_ARCHIVE_DEST failed
  • ora-22926 : specified trim length is greater than current LOB value's length
  • ora-02267 : column type incompatible with referenced column type
  • ora-21524 : object type mismatch
  • ora-01165 : MAXDATAFILES may not exceed string
  • ora-16799 : Redo Apply is offline
  • ora-30011 : Error simulated: psite=string, ptype=string
  • ora-22855 : optional name for LOB storage segment incorrectly specified
  • ora-14519 : Conflicting tablespace blocksizes for string string: Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]
  • ora-10560 : block type 'string'
  • ora-13066 : wrong feature geometry or element type
  • ora-36165 : (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.
  • ora-19924 : there are no row with id string
  • ora-06112 : NETTCP: invalid buffer size
  • ora-29935 : missing FROM keyword
  • ora-08462 : raw buffer contains invalid decimal data
  • ora-16253 : Logical Standby cannot start due to incomplete terminal apply
  • ora-27009 : skgfwrt: cannot write to file opened for read
  • ora-06735 : TLI Driver: client failed to close error conn
  • ora-02356 : The database is out of space. The load cannot continue
  • ora-31011 : XML parsing failed
  • ora-39753 : unsupported use of subquery in PARTITIONED OUTER JOIN condition
  • ora-09266 : spawn: error starting an Oracle process
  • ora-25123 : Too many components specified in the name.
  • ora-04050 : invalid or missing procedure, function, or package name
  • ora-19241 : XP0021 - cast to type string failed
  • ora-27216 : skgfgsmcs: sbtinfo2 returned a malformed response
  • ora-12066 : invalid CREATE MATERIALIZED VIEW command
  • 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.