UPDATE END USER CONTEXT

Purpose

Use the UPDATE statement on the SYS.END_USER_CONTEXT view to set or modify the value of an attribute for a given context.

Prerequisites

You must have either UPDATE ANY END USER CONTEXT system privilege, or, have the UPDATE privilege granted through a data grant on SYS.END_USER_CONTEXT view for the specific context.

You must have the SELECT privilege to update a context attribute because updating a context attribute automatically instantiates the context if it has not been done already. In other words, when updating a new, unused context for the first time, both UPDATE and SELECT privileges are required.

Syntax


Description of modify_end_user_context.eps follows
Description of the illustration modify_end_user_context.eps

Semantics

  • owner: owner of the context

  • name: name of the context

  • attribute: attribute in context

  • value: the value to be set for the attribute

Restrictions

You cannot use bind variables to update end-user contexts.

Example

The following SQL statement sets the value for attribute emp_id in context HR.HCM to 3: 


UPDATE END_USER_CONTEXT t SET t.CONTEXT.emp_id = 3 

  WHERE owner = 'HR' and name = 'HCM';