Home » Developer & Programmer » Forms » Ora-302000
Ora-302000 [message #73208] Tue, 02 March 2004 20:41 Go to next message
Bernard Njowera
Messages: 1
Registered: March 2004
Junior Member
I am loading a text file into oracle database using a form and am getting an ORA-302000.

How do I rectify it?

Best regards.
Re: Ora-302000 [message #73210 is a reply to message #73208] Wed, 03 March 2004 02:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10613
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
if you are using a TEXT_IO.FOPEN in ur form,
Make sure u give a COMPLETE path to the concerned file
Re: Ora-302000 [message #73287 is a reply to message #73208] Wed, 17 March 2004 00:18 Go to previous messageGo to next message
Khurram Siddiqui
Messages: 5
Registered: March 2004
Junior Member
Use this Code in Tirgger On-Error Form Level

DECLARE
errnum NUMBER := ERROR_CODE;
errtxt VARCHAR2(80) := ERROR_TEXT;
errtyp VARCHAR2(3) := ERROR_TYPE;
BEGIN
IF errnum = 40735 THEN
Message('Your Messge......');
else
Message(errtyp||'-'||TO_CHAR(errnum)||': '||errtxt);
RAISE Form_Trigger_Failure;
END IF;
END;
Re: Ora-302000 [message #73830 is a reply to message #73210] Tue, 20 July 2004 21:37 Go to previous messageGo to next message
Eran Ben-ari
Messages: 1
Registered: July 2004
Junior Member
u r propbably trying to get_line from a closed file or
somthing like that.

use this:

EXCEPTION
WHEN OTHERS
THEN
IF SQLCODE = -302000
THEN
LOOP
EXIT WHEN TOOL_ERR.NERRORS = 0;
MESSAGE (TO_CHAR(TOOL_ERR.CODE) || ': ' || TOOL_ERR.MESSAGE);
TOOL_ERR.POP;
END LOOP;
END IF;
END;

to catch and handle u'r exception....
Re: Ora-302000 [message #327357 is a reply to message #73208] Mon, 16 June 2008 03:55 Go to previous messageGo to next message
Ora_ardor
Messages: 9
Registered: March 2006
Location: PAKISAN
Junior Member


Dear User,


This error raises when you are trying to load text file from client usign Text_IO and the procedure Fopen does not find the
file path

For example

TEXT_IO.FOPEN('C:\SOURCE\data.txt','w');

but there is no folder like SOURCE ON C: DRIVE THEN
ORA-302000 WILL BE RAISED

JUST GIVE AN EXACT PATH THEN IN TEXT_IO.FOPEN

( IN CLIENT SERVER ENV )

Regards,
ASIF IQBAL

Re: Ora-302000 [message #556192 is a reply to message #327357] Thu, 31 May 2012 15:47 Go to previous message
luisen22
Messages: 1
Registered: May 2012
Junior Member
that solve my problem, thanks
Previous Topic: COMMENT BUTTON Set_ICO_Property
Next Topic: Passing info. thru forms
Goto Forum:
  


Current Time: Sun Apr 20 16:11:43 CDT 2014

Total time taken to generate the page: 0.04207 seconds