Project and Portfolio Management Practitioners Forum
cancel

Is it possible to change the Users User Data value without calling a function or procedure

Highlighted
kndlny
Super Contributor.

Is it possible to change the Users User Data value without calling a function or procedure

Hi,

 

I wonder whether it is possible to update Users User Data without calling a function or procedure which has an UPDATE statement.

 

In other words, is it possible to update this user data inside a workflow step.

 

I have tried

 

ksc_store USR="[REQ.CREATED_BY_USERNAME]".US.USERDATA = "[REQ.P.MY_TOKEN]","[REQ.VP.MY_TOKEN]"

 

and

 

ksc_set USR="[REQ.CREATED_BY_USERNAME]".US.USERDATA = "[REQ.P.MY_TOKEN]"

ksc_set USR="[REQ.CREATED_BY_USERNAME]".VUS.USERDATA = "[REQ.VP.MY_TOKEN]"

 

both ways did not update the users user data value.

 

Is there another way I can update this value without using a db function_

 

Thanks

 

1 REPLY
philipwood
Super Contributor.

Re: Is it possible to change the Users User Data value without calling a function or procedure

Not much of an alternative, but you could use ksc_local execute to call sqlplus to execute the desired update statement - either a a script or as an command line parameter.