Home » Developer & Programmer » Forms » ora-302000non oracle error
ora-302000non oracle error [message #231554] Tue, 17 April 2007 08:49 Go to next message
roopa.apps@gmail.com
Messages: 6
Registered: April 2007
Location: INDIA
Junior Member
i am using forms 10G and trying to write data to flat file using webutil pkg. i configured webutil package and while trying to write the data, its generating the file in my c drive but with empty records and throws error-302000 non oracle exception....any suggestions please.
Re: ora-302000non oracle error [message #231632 is a reply to message #231554] Tue, 17 April 2007 15:13 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you should post some code in order to help us better understand what happened there.
Re: ora-302000non oracle error [message #231661 is a reply to message #231554] Tue, 17 April 2007 23:30 Go to previous messageGo to next message
roopa.apps@gmail.com
Messages: 6
Registered: April 2007
Location: INDIA
Junior Member
HI.......

Following is the some code which to print a flat file at specified path .

declare
cursor c1 is
select hd.order_no,
	hd.written_date,
	sku.ORIGIN_COUNTRY_ID,
	su.sup_name ;
	out_file   client_Text_IO.File_Type;
	po_number  number;
begin
  out_file := client_Text_IO.Fopen(:file_path ||'\'||'Mx'||:PO_NUMBER, 'W');
  for po_submit in c1 loop
  client_Text_IO.Put_Line(out_file,
                   '0~'||
	po_submit.order_no||'~'||
	'0~'||
	po_submit.written_date||'~'||
	po_submit.ORIGIN_COUNTRY_ID||'~'||
	po_submit.sup_name||'~'||                         
	);				
  end loop;	
	client_Text_IO.Fclose(out_file);
	EXCEPTION
  	  when FORM_TRIGGER_FAILURE then
      raise;
      WHEN no_data_found THEN
      emessage('no data found file cannot be generated');
      Text_IO.Put_Line('Closing the file...');
      Text_IO.Fclose(out_file);
      when OTHERS then
      emessage(SQLERRM);
      raise FORM_TRIGGER_FAILURE; 
END;

NEED HELP.

Upd-mod: Added code tags and got rid of the blank lines.

[Updated on: Thu, 19 April 2007 21:33] by Moderator

Report message to a moderator

Re: ora-302000non oracle error [message #231901 is a reply to message #231661] Wed, 18 April 2007 15:26 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happens if you omit the WHEN OTHERS exception handler? Just comment this part of code, compile the form and try it again.
Re: ora-302000non oracle error [message #232242 is a reply to message #231661] Thu, 19 April 2007 21:38 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I suggest that you populate a variable with your concatenated data and then write that variable instead of writing the concatenation directly. I think that you are trying to write a line that is too long. Check the doucmentation concerning the maximum line length.

David
Re: ora-302000non oracle error [message #232263 is a reply to message #231554] Thu, 19 April 2007 23:39 Go to previous message
roopa.apps@gmail.com
Messages: 6
Registered: April 2007
Location: INDIA
Junior Member
Hi....


Finally i was able to write it.
changes i made to achive this:
1.in forms90 path i have webutil.pll,plx. i have replaced them with the webutil1.06 pll,plx and then attched them to my form.
2.changed the object library also to new object library
3. compiled the form

and given a try again.its writing sucessfully...
Thanks for your support...


Roopa.
Previous Topic: FRM-41213
Next Topic: Sending Fax using Oracle Forms 6i
Goto Forum:
  


Current Time: Wed Dec 07 22:12:36 CST 2016

Total time taken to generate the page: 0.08886 seconds