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 : 21-07-2017
ORA-24304

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

  • ora-02253 : constraint specification not allowed here
  • ora-19261 : XQ0041 - non empty URI in QName
  • ora-13871 : Invalid instance name
  • ora-31196 : XML nodes over string in size cannot be printed
  • ora-31080 : type not specified for attribute or element "string"
  • ora-31091 : empty string specified as a SQL name
  • ora-10943 : trace name context forever
  • ora-16208 : Logical standby dictionary build failed to start.
  • ora-14017 : partition bound list contains too many elements
  • ora-02227 : invalid cluster name
  • ora-06547 : RETURNING clause must be used with INSERT, UPDATE, or DELETE statements
  • ora-12685 : Native service required remotely but disabled locally
  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-09945 : Unable to initialize the audit trail file
  • ora-27144 : attempt to kill process failed
  • ora-19816 : WARNING: Files may exist in string that are not known to database.
  • ora-03240 : User's temporary tablespace same as tablespace being migrated
  • ora-23505 : Object "string"."string" is missing.
  • ora-10921 : Cannot drop tablespace belonging to default temporary tablespace group
  • ora-02726 : osnpop: access error on oracle executable
  • ora-24080 : unschedule_propagation pending for QUEUE string and DESTINATION string
  • ora-30074 : GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
  • ora-26082 : load of overlapping segments on table string.string is not allowed
  • ora-01989 : role 'string' not authorized by operating system
  • ora-28038 : disallow O2LOGON
  • ora-25472 : maximum open iterators exceeded
  • ora-24406 : API mode switch is disallowed when a call is in progress.
  • ora-12997 : cannot drop primary key column from an index-organized table
  • ora-12165 : TNS:Trying to write trace file into swap space.
  • ora-14298 : LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • 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.