Global Variable length problem
864019Jan 30 2012 — edited Jan 31 2012Hi All,
I am trying to pass a group of key values to a pll.
I am holding all this key values in a text field which can hold upto 10000 bytes and I am assigning this text field values to a global variable.
This global variable value is read by pll and fetch the records using those key values.
But I am getting run time error of ORA-06502. It is a issue regarding the length of the variable.
From Form builders help I came to know that Global variable can hold only upto 5000 bytes.
Suppose
New_id is a text field which has more than 7000 bytes values seperated by comma's
New_id is a text field of type char length is 10000,
+:global.new_cust_id:=block.new_id;+
At this line I am getting the ORA-06502 error, As this global value is used by some other packages.
Can any one help how can I Resolve this problem
I use Forms [32 Bit] Version 11.1.1.4.0 (Production) and Oracle 11g R2 database
Thanks,
maddy