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

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

  • ora-16254 : change db_name to string in the client-side parameter file (pfile)
  • ora-31075 : invalid string declaration in XML Schema
  • ora-31154 : invalid XML document
  • ora-23474 : definition of "string"."string" has changed since generation of replication support
  • ora-13641 : Task cannot be interrupted yet. You may cancel it instead.
  • ora-12536 : TNS:operation would block
  • ora-13192 : failed to read number of element rows
  • ora-01576 : The instance string is not enabled
  • ora-24159 : invalid variable definiton
  • ora-27074 : unable to determine limit for open files
  • ora-08230 : smscre: failed to allocate SGA
  • ora-12626 : TNS:bad event type
  • ora-06513 : PL/SQL: index for PL/SQL table out of range for host language array
  • ora-09872 : TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.
  • ora-38737 : Expected sequence number string doesn't match string
  • ora-00042 : Unknown Service name string
  • ora-28183 : proper authentication not provided by proxy
  • ora-29558 : JAccelerator (NCOMP) not installed. Refer to Install Guide for instructions.
  • ora-07599 : spwat: $SCHDWK failure
  • ora-14186 : number of sub-partitions of LOCAL index must equal that of the underlying table
  • ora-00912 : input parameter too long
  • ora-19245 : XQ0025 - duplicate attribute name string
  • ora-33313 : (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
  • ora-38772 : cannot add datafile 'string' - file could not be created
  • ora-07569 : slspool: $CLOSE failure
  • ora-24005 : must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
  • ora-30081 : invalid data type for datetime/interval arithmetic
  • ora-14634 : Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table
  • ora-10372 : parallel query server kill event proc
  • ora-19287 : XP0017 - invalid number of arguments to function - string:string
  • 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.