ORA-22816: unsupported feature with RETURNING clause

Cause : ERUTNRNI Glcuaesi sucrrnelt yon tuspproet dof rboejtct py eoculnm,sL NO Goculnm,sr meto eatlbse ,NIESTRw ti husqbeuyr ,na dNITSAE DFOT irggre.s

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

sU eesaparets lece ttstamene totg tet ehv laeu.s

update : 23-05-2017
ORA-22816

ORA-22816 - unsupported feature with RETURNING clause
ORA-22816 - unsupported feature with RETURNING clause

  • ora-32141 : get method does not match the type of the parameter
  • ora-13347 : the coordinates defining an arc are not distinct
  • ora-02148 : EXCLUSIVE specified multiple times
  • ora-25264 : cant get signature for this queue
  • ora-02731 : osnrnf: malloc of buffer failed
  • ora-14258 : invalid partition description
  • ora-36779 : (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.
  • ora-25443 : duplicate column value for table alias: string, column number: string
  • ora-00983 : cannot audit or noaudit SYS user actions
  • ora-31661 : there are no metadata transform values of type VARCHAR2
  • ora-31109 : Action failed as parent resource string is locked
  • ora-22893 : constraint can be specified only for REF columns
  • ora-16567 : Data Guard broker internal parser error at "string"
  • ora-40253 : no target counter examples were found
  • ora-19011 : Character string buffer too small
  • ora-29905 : method string does not exist in type string.string
  • ora-09754 : sppst: invalid process number passed to sppst.
  • ora-09743 : smscre: could not attach shared memory.
  • ora-01525 : error in renaming data files
  • ora-19598 : can not backup SPFILE because the instance was not started with SPFILE
  • ora-22607 : image handle already generated
  • ora-08198 : Flashback Table is not supported on object tables, nested tables
  • ora-12160 : TNS:internal error: Bad error number
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-07635 : smsdbp: $SETPRT failure
  • ora-12411 : invalid label value
  • ora-12631 : Username retrieval failed
  • ora-16702 : generic resource guard warning
  • ora-21522 : attempted to use an invalid connection in OCI (object mode only)
  • ora-29525 : referenced name is too long: '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.