ORA-26747: The one-to-many transformation function string encountered the following error: string

Cause : The psecifeid trnasforamtionf unctoin enocunteerd ane rror.

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

Ensuer tha tthe ufnctino doe snot rpoces sor rteurn DDL LCsR. Alos ensrue thta thef unctoin dose notr etur nNULL.

update : 29-04-2017
ORA-26747

ORA-26747 - The one-to-many transformation function string encountered the following error: string
ORA-26747 - The one-to-many transformation function string encountered the following error: string

  • ora-31012 : Given XPATH expression not supported
  • ora-04065 : not executed, altered or dropped string
  • ora-25314 : a commit-time queue table cannot be migrated to 8.0
  • ora-32056 : invalid number of extents
  • ora-01603 : illegal grouping size in clause "string" of string
  • ora-19701 : device name exceeds maximum length of string
  • ora-31631 : privileges are required
  • ora-39015 : job is not running
  • ora-25246 : listen failed, the address string is an 8.0 style exception queue
  • ora-38733 : Physical size string less than needed string.
  • ora-30153 : An invalid File Object is passed to the OCIFile function
  • ora-19911 : datafile string contains future changes at the incarnation boundary
  • ora-19682 : file string not in block media recovery context
  • ora-13600 : error encountered in Advisor string
  • ora-19813 : cannot have unavailable file string in DB_RECOVERY_FILE_DEST
  • ora-24144 : rules engine internal error, arguments: [string], [string]
  • ora-00019 : maximum number of session licenses exceeded
  • ora-09800 : Process sensitivity label retrieval failed.
  • ora-29832 : cannot drop or replace an indextype with dependent indexes
  • ora-24435 : Invalid Service Context specified.
  • ora-22929 : invalid or missing directory name
  • ora-38101 : Invalid column in the INSERT VALUES Clause: string
  • ora-16115 : %s\% of LogMiner dictionary loading is done
  • ora-30185 : output too large to fit in the buffer
  • ora-24046 : protocol attribute reserved for future use
  • ora-14050 : invalid ALTER INDEX MODIFY PARTITION option
  • ora-12411 : invalid label value
  • ora-16655 : specified target standby database invalid
  • ora-26502 : error resignal
  • ora-24270 : a row already exists in the string table for these parameters
  • 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.