ORA-28261: CURRENT_USER can not be used in PLSQL Definer's Right procedure.

Cause : An attmept to ertrieveC URRENTU_SER usnig SYS_OCNTEXT LPSQL inetrface.

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

Use a QSL statmeent toq uery CRURENT_UESR insied a DR rpocedur.e

update : 28-06-2017
ORA-28261

ORA-28261 - CURRENT_USER can not be used in PLSQL Definer's Right procedure.
ORA-28261 - CURRENT_USER can not be used in PLSQL Definer's Right procedure.

  • ora-03123 : operation would block
  • ora-38478 : creation of system trigger EXPFIL_DROPOBJ_MAINT failed
  • ora-13285 : Geometry coordinate transformation error
  • ora-31215 : DBMS_LDAP: PL/SQL - Invalid LDAP mod value.
  • ora-38417 : attribute set string does not exist
  • ora-09931 : Unable to open ORACLE password file for reading
  • ora-29355 : NULL or invalid string argument specified
  • ora-14134 : indexes cannot use both DESC and REVERSE
  • ora-02818 : Less than the number of blocks requested was read in
  • ora-01039 : insufficient privileges on underlying objects of the view
  • ora-07453 : requested resource manager plan schema does not contain OTHER_GROUPS
  • ora-31039 : XML namespace length string exceeds maximum string
  • ora-12924 : tablespace string is already in force logging mode
  • ora-01203 : wrong incarnation of this file - wrong creation SCN
  • ora-12736 : Instant Client Light: unsupported server national character set string
  • ora-36696 : (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.
  • ora-37173 : null dimension source data
  • ora-13207 : incorrect use of the [string] operator
  • ora-09756 : osnpns: no port in the name server.
  • ora-29296 : invalid encoded string
  • ora-19810 : Cannot create temporary control file string in DB_RECOVERY_FILE_DEST
  • ora-31091 : empty string specified as a SQL name
  • ora-13639 : The current operation was interrupted because it timed out.
  • ora-19260 : XQ0040 - invalid namespace node in element constructor
  • ora-06706 : TLI Driver: service not found
  • ora-28265 : NameSpace beginning with 'sys_' is not allowed
  • ora-29800 : invalid name for operator
  • ora-10936 : trace name context forever
  • ora-25257 : consumer must be specified with a multi-consumer queue
  • ora-29254 : Invalid lower_bound argument passed to procedure dbms_sql.define_array
  • 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.