| Problem using editor [message #80958] |
Tue, 17 December 2002 23:15  |
Gopal
Messages: 23
Registered: June 1999
|
Junior Member |
|
|
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
