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: 10707
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 messageGo to next message
luisen22
Messages: 1
Registered: May 2012
Junior Member
that solve my problem, thanks
Re: Ora-302000 [message #668710 is a reply to message #327357] Mon, 12 March 2018 06:00 Go to previous message
syedferhat
Messages: 17
Registered: February 2013
Location: Karachi, Pakistan
Junior Member
Dear Imran

I am using following code the path and file are 100% correct but still giving error /exception

I m using forms 6i and connecting with 10g database

can you please why or share some running code example

Thanks

DECLARE
file1 TEXT_IO.FILE_TYPE;
file2 TEXT_IO.FILE_TYPE;
str VARCHAR2(1000);
errnum NUMBER := ERROR_CODE;
errtxt VARCHAR2(80) := ERROR_TEXT;
errtyp VARCHAR2(3) := ERROR_TYPE;

BEGIN
file1 := TEXT_IO.FOPEN( 'C:\IQBAL\reports.txt','r' );
file2 := TEXT_IO.FOPEN( 'C:\IQBAL\output.txt', 'w' );
TEXT_IO.GET_LINE( file1, str );
TEXT_IO.PUT_LINE( file2, str );
TEXT_IO.FCLOSE( file1 );
TEXT_IO.FCLOSE( file2 );
EXCEPTION
WHEN OTHERS
THEN
IF SQLCODE = -302000 then
Message(errtyp||'-'||TO_CHAR(errnum)||': '||errtxt);
Message(errtyp||'-'||TO_CHAR(errnum)||': '||errtxt);
end if;
END;
Previous Topic: Import excel file in oracle
Next Topic: Problem calling database procedure
Goto Forum:
  


Current Time: Thu Mar 28 03:24:56 CDT 2024