ORA-28555: pass-through SQL: required parameter missing or NULL

Cause : An attmept wasm ade top ass a UNLL valeu to a onn-NULLp arametre.

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

Use a onn-NULLv alue fro the praameter.

update : 26-09-2017
ORA-28555

ORA-28555 - pass-through SQL: required parameter missing or NULL
ORA-28555 - pass-through SQL: required parameter missing or NULL

  • ora-31481 : change source string is not a HotLog change source
  • ora-25127 : RELY not allowed in NOT NULL constraint
  • ora-09818 : Number is too large
  • ora-13615 : The task or object string is greater than the maximum allowable length of 30 characters.
  • ora-01874 : time zone hour must be between -12 and 14
  • ora-38441 : System could not derive the list of STORED and INDEXED attributes.
  • ora-14196 : Specified index cannot be used to enforce the constraint.
  • ora-16800 : redo transport service for a standby database incorrectly set to ALTERNATE
  • ora-00263 : there are no logs that need archiving for thread string
  • ora-13152 : invalid HHCODE type
  • ora-36167 : (XSAGGRFORM) workspace object is an illegal AGGMAP for aggregating a FORMULA.
  • ora-02493 : invalid file increment size in NEXT clause
  • ora-32103 : error from OCI call
  • ora-23387 : replication parallel push dequeue error
  • ora-19553 : device name string is invalid
  • ora-16104 : invalid Logical Standby option requested
  • ora-14626 : values being added already exist in DEFAULT subpartition
  • ora-01921 : role name 'string' conflicts with another user or role name
  • ora-01552 : cannot use system rollback segment for non-system tablespace 'string'
  • ora-00381 : cannot use both new and old parameters for buffer cache size specification
  • ora-25199 : partitioning key of a index-organized table must be a subset of the primary key
  • ora-09322 : slpdtb: unable to convert packed decimal to binary
  • ora-28363 : buffer provided not large enough for output
  • ora-00702 : bootstrap verison 'string' inconsistent with version 'string'
  • ora-24026 : operation failed, queue string.string has errors
  • ora-27197 : skgfprs: sbtpcrestore returned error
  • ora-24787 : remote cursors must be closed before a call completes
  • ora-39139 : Data Pump does not support XMLSchema objects. string will be skipped.
  • ora-13278 : failure to convert SRID to native format
  • ora-00408 : parameter string is set to TRUE
  • 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.