Home » Developer & Programmer » Forms » ORA - 01403 no data found
ORA - 01403 no data found [message #120320] Thu, 19 May 2005 01:25 Go to next message
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 #120322 is a reply to message #120320] Thu, 19 May 2005 02:02 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Change the type 'char' to 'varchar'.
Re: ORA - 01403 no data found [message #120340 is a reply to message #120320] Thu, 19 May 2005 03:43 Go to previous messageGo to next message
Gokul
Messages: 21
Registered: October 2000
Junior Member


In Oracle Forms9i there is no datatype called varchar for text_item. Available data type for char is LONG, CHAR, ALPHA.
Re: ORA - 01403 no data found [message #120342 is a reply to message #120340] Thu, 19 May 2005 03:52 Go to previous messageGo to next message
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
Re: ORA - 01403 no data found [message #120356 is a reply to message #120320] Thu, 19 May 2005 04:43 Go to previous message
Gokul
Messages: 21
Registered: October 2000
Junior Member


my mistake is
the content of text_item was assigned to var whose length is 400 ie(<2048).

I Corrected my problem.

Thanks for your reply.
Previous Topic: problem in connectign sqlserver with develoepr6i forms
Next Topic: BLOB can not replicate on the Network.
Goto Forum:
  


Current Time: Thu Sep 19 18:58:35 CDT 2024