daogu

I am adding to a global variable in a form everytime a button is pressed, when the global variable gets to a certain number it gives me an error ORA-06502, is there a maximum length on global variables:

:global.old_emp_no := nvl(:control_x.empl_num_view, 0)||’, ‘||:global.old_emp_no;

:global.old_emp_no:= vnum;

when I am finished adding to the global variable I use it in a query

Set_Block_Property(’BSI_EMPL_MASTER_V’,DEFAULT_WHERE,’employee_number IN (’||rtrim(vnum,’, ‘)||’) ‘||’ORDER BY EMPLOYEE_NUMBER’);

---

Answer:As Forms Online Help System suggests,

Quote:

A global variable stores a character string of up to 255 characters in length.

---

Answer:thanks, but do you have any idea of why I am getting an unhandled exception when, my variable vnnum gets larger, i am also getting ora-06502

What I am doing is the user is selecting employees from a list the employee id number is takend and stored in vnum, with concatenation I add a comma, when the user adds more than 40 employee id numbers i get the above error, Im thinking my variable vnum may not be large enough (vnum varchar2(32600)) is there another datatype or way I can accept large amounts of data from the user?

---

Answer:Have you solved your problem?

David

---

Answer:No I havent.

---

Answer:Use multiple fields. Test the length on the current field and if it is nearly full then place the new selection criteria into the next field.

I would also consider using a table to store the information that is used in the query. That way, Oracle can use indexes and other database features to make the query more efficient.

David

Related posts:

1. Global Variables How to Access Global Variables of one form into...
2. Global variables and some CAN UEXPLAIN THESE THINGS HOW ITS WORKS I MENA...
3. frm 499815,global.n_lang_code when i open a new form (runtime) this show...
4. problem with global value while inserting from calling form hello all, im using global variable to get the...
5. How to auto populate a 2nd form from another form by using Global variable I created a form which contains 2 text items...