ORA-24304: datatype not allowed for this call

Cause : Data of this datatype cannot be sent or fetched in pieces.

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

Use other bind or define calls for this datatype.

update : 26-09-2017

ORA-24304 - datatype not allowed for this call
ORA-24304 - datatype not allowed for this call

  • ora-13601 : The specified Advisor string does not exist.
  • ora-01669 : standby database control file not consistent
  • ora-04061 : existing state of string has been invalidated
  • ora-32006 : %s initialization parameter has been deprecated
  • ora-29347 : Tablespace name validation failed - failed to match tablespace 'string'
  • ora-22954 : This multiset operation is not supported for this element type.
  • ora-01073 : fatal connection error: unrecognized call type
  • ora-03234 : unable to extend index string.string subpartition string by string in tablespace string
  • ora-01153 : an incompatible media recovery is active
  • ora-25144 : invalid option for CREATE TABLESPACE with TEMPORARY contents
  • ora-31673 : worker process interrupt for normal exit by master process
  • ora-01032 : no such userid
  • ora-19334 : Invalid column specification for CREATE_DBURI operator
  • ora-19585 : premature end of volume on piece string
  • ora-12345 : user string lacks CREATE SESSION privilege in database link (linkname string)
  • ora-01228 : SET DATABASE option required to install seed database
  • ora-14020 : this physical attribute may not be specified for a table partition
  • ora-32159 : Cannot set prefetch options for a null Type
  • ora-30175 : invalid type given for an argument
  • ora-39015 : job is not running
  • ora-14275 : cannot reuse lower-bound partition as resulting partition
  • ora-19581 : no files have been named
  • ora-03278 : duplicate ALLOCATE EXTENT option specification
  • ora-13019 : coordinates out of bounds
  • ora-17504 : ksfddel:Failed to delete file string
  • ora-30043 : Invalid value 'string' specified for parameter 'Undo_Management'
  • ora-03222 : average row size and row count must be greater than zero
  • ora-27066 : number of buffers in vector I/O exceeds maximum
  • ora-22896 : cannot have both scope and referential constraint on REF column "string"
  • ora-32632 : incorrect subquery in MODEL FOR cell index
  • 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.