Hi,

We have a text field ITEM_NAME of width 240 in block BLOCK_NAME. Field having width more than 60, we provide Editor box. There will be a button provided near text field, by clicking the button the editor will be shown. The following is done in when-button-pressed of M_BUT_EDIT_ITEM_NAME

BEGIN
SHOW_EDITOR(:BLOCK_NAME.ITEM_NAME);
END;

The procedure SHOW_EDITOR is as given below,

PROCEDURE SHOW_EDITOR (P_STR IN OUT VARCHAR2) IS
M_OK BOOLEAN;
M_RES VARCHAR2(2000) ;
BEGIN

SHOW_EDITOR('STD_EDITOR', P_STR, M_RES, M_OK);
IF M_OK THEN
P_STR := M_RESULT;
END IF ;

END;

The P_STR will have the value of the text field. Now the problem is as below. The procedure is in a pll and is implemented in various places. Even if the field width is 240, the editor box accepts more than 240 resulting in ora-6502. I want the solution by not disturbing the calling place of the procedure. The changes can be made only in the PLL. is there any solution???

Note : We dont attach the editor to the text field. A separate button takes care of it