Home » Developer & Programmer » Forms » Problem using editor
Problem using editor [message #80958] Tue, 17 December 2002 23:15 Go to next message
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
Re: Problem using editor [message #80960 is a reply to message #80958] Wed, 18 December 2002 00:47 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You cannot assign a length to an editor or limit the length of an editor. Why don't you use EDIT_TEXTITEM instead?

MHE
Previous Topic: Re: tutorial for oracle developer2000
Next Topic: Overwrite the menu!!
Goto Forum:
  


Current Time: Fri Mar 29 06:07:08 CDT 2024