ORA - 01403 no data found [message #120320] |
Thu, 19 May 2005 01:25 |
Gokul
Messages: 21 Registered: October 2000
|
Junior Member |
|
|
Iam having a table with column datatype as varchar2(2048)
In Forms9i(release 9.0.2)
i have created a non-database block's text_item
with the following Properties(some):
Data Type : Char
Data Length Semantics : BYTE
Maximum Length : 2048
I had a editor ,
when user mouse-clicks on the text_item Using SHOW_EDITOR iam displaying the contents of text_item to Editor and vice-versa.
(This works finely when the column size is varchar2(255);
My Problem :
1)Now, when I mouse-click on the text_item which is empty editor is displayed when i enter text of length 300 and press OK it dispays the following error
FRM - 40735 WHEN-MOUSE-CLICK raised unhandled exception
ORA - 01403 no data found
2) But iam able to enter text of length 2048 in the text_item directly(without using editor).
3) when I mouse-click on the text_item havimg a text of mor than some limit it dispays the following error
FRM - 40735 WHEN-MOUSE-CLICK raised unhandled exception
ORA - 01403 no data found
Plz. tell me solution for this.
Thanks in advance for your reply.
|
|
|
|
|
Re: ORA - 01403 no data found [message #120342 is a reply to message #120340] |
Thu, 19 May 2005 03:52 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
My apologies, I should have fired up the Forms Builder first.
Show_editor expects varchar2 as the data type, try the following.
/*
** Built-in: SHOW_EDITOR
** Example: Accept input from the operator in a user-defined
** editor. Use the system editor if the user has
** checked the "System_Editor" menu item under the
** "Preferences" menu in our custom menu module.
*/
DECLARE
ed_id Editor;
mi_id MenuItem;
ed_name VARCHAR2(40);
val VARCHAR2(32000);
ed_ok BOOLEAN;
BEGIN
mi_id := Find_Menu_Item('PREFERENCES.SYSTEM_EDITOR');
IF Get_Menu_Item_Property(mi_id,CHECKED) = 'TRUE' THEN
ed_name := 'system_editor';
ELSE
ed_name := 'my_editor1';
END IF;
ed_id := Find_Editor( ed_name );
/*
** Show the appropriate editor at position (10,14) on the
** screen. Pass the contents of the :emp.comments item
** into the editor and reassign the edited contents if
** 'ed_ok' returns boolean TRUE.
*/
val := :emp.comments;
Show_Editor( ed_id, val, 10,14, val, ed_ok);
IF ed_ok THEN
:emp.comments := val;
END IF;
END;
That is, use a real varchar2 in the argument list, and then assign it to your text_item.
David
|
|
|
|