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

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

  • ora-23374 : object group "string"."string" already exists
  • ora-32400 : cannot use object id columns from materialized view log on "string"."string"
  • ora-06255 : NETNTT: cannot read pid of remote process
  • ora-27300 : OS system dependent operation:string failed with status: string
  • ora-01553 : MAXEXTENTS must be no smaller than the string extents currently allocated
  • ora-09807 : Conversion of label from string to binary failed.
  • ora-19695 : fixed table x$krbmsft has not been populated
  • ora-16209 : Logical standby dictionary build failed to complete.
  • ora-09282 : sllfrb: error reading records
  • ora-23448 : duplicate user parameter value
  • ora-03251 : Cannot issue this command on SYSTEM tablespace
  • ora-14052 : partition-extended table name syntax is disallowed in this context
  • ora-38785 : Media recovery must be enabled for guaranteed restore point.
  • ora-09934 : Link of current password file to old failed.
  • ora-24372 : invalid object for describe
  • ora-00102 : network protocol string cannot be used by dispatchers
  • ora-19501 : read error on file "string", blockno string (blocksize=string)
  • ora-14075 : partition maintenance operations may only be performed on partitioned indices
  • ora-01478 : array bind may not include any LONG columns
  • ora-08265 : create_ora_addr: cannot open nameserver
  • ora-09811 : Unable to initialize package.
  • ora-24093 : AQ agent string not granted privileges of database user string
  • ora-25007 : functions or methods not allowed in WHEN clause
  • ora-14615 : List value 'string' specified twice in subpartitions 'string', 'string'
  • ora-13635 : The value provided for parameter string cannot be converted to a number.
  • ora-01556 : MINEXTENTS for rollback segment must be greater than 1
  • ora-16612 : string value too long for attribute "string"
  • ora-12547 : TNS:lost contact
  • ora-29526 : created Java class string"string"
  • ora-14626 : values being added already exist in DEFAULT subpartition
  • 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.