ORA-23325: parameter type is not string

Cause : A conflict resolution priority function was given a type different than the type assigned to the priority group; or the priority group has no type assigned or a function; or dbms_defer_sys_query was called to retrieve a deferred rpc parameter from the deferred rpc queue, but the type of the parameter does not match the return type of the function.

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

Use the function corresponding to the parameter type.

update : 23-09-2017
ORA-23325

ORA-23325 - parameter type is not string
ORA-23325 - parameter type is not string

  • ora-19039 : Keyword string reserved for future use
  • ora-40282 : invalid cost matrix
  • ora-01669 : standby database control file not consistent
  • ora-06266 : NETNTT: bad write length
  • ora-00082 : memory size of string is not in valid set of [1], [2], [4]stringstringstringstringstring
  • ora-12854 : Parallel query is not supported on temporary LOBs
  • ora-16782 : instance not open for read and write access
  • ora-19243 : XQ0023 - invalid document node content in element constructor
  • ora-12077 : temporary updatable materialized view log does not exist
  • ora-26713 : remote object does not exist or is inaccessible
  • ora-23335 : priority group string already exists
  • ora-16400 : quota attributes are not allowed with DB_RECOVERY_FILE_DEST
  • ora-25961 : join index prevents dml cascade constraint operation
  • ora-12473 : The procedure is disabled when Label Security is used with OID.
  • ora-07282 : sksaprd: string overflow.
  • ora-06571 : Function string does not guarantee not to update database
  • ora-13026 : unknown element type for element string.string.string
  • ora-01902 : SEGMENT keyword expected
  • ora-13371 : invalid position of measure dimension
  • ora-09854 : snyPortInfo: bad return code from request.
  • ora-07708 : sksaprs: tape label name buffer too small
  • ora-10583 : Can not recovery file string renamed as missing during test recovery
  • ora-02313 : object type contains non-queryable type string attribute
  • ora-31401 : change source string is not an existing change source
  • ora-12030 : cannot create a fast refresh materialized view
  • ora-19628 : invalid SCN range
  • ora-24239 : object could not be invalidated
  • ora-30956 : invalid option for XML Index
  • ora-38306 : this object is not recoverable standalone
  • ora-28594 : agent control utility: invalid parameter name
  • 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.