EBS Customizations (MOSC)

MOSC Banner

How to assign global variable under a procedure built in of forms personalization?

edited Mar 31, 2011 10:17PM in EBS Customizations (MOSC) 5 commentsAnswered ✓
Hi All,
I am trying to execute a procedure builtin action of form personalization but facing issues while assigning a value to global variable.

Code is as  below :
 
='begin
IF '''||${global.xx_sys.value}||''' = '''||${global.XX_START.value}||''' then
:global.XX_TEMP := 234;
END IF;
End'

IF clause is working properly, but the assignment is failing with error
"ORA-01008 Not all variables bound"

I have tried '''||:global.XX_TEMP||''' but the actual variable value is retrieved eg. 123 and the assignment is failing.
What is the syntax to assign a global variable in a forms personalization procedure?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center