| Ora-302000 [message #73208] |
Tue, 02 March 2004 20:41  |
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 #73287 is a reply to message #73208] |
Wed, 17 March 2004 00:18  |
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 |
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 |
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 #668710 is a reply to message #327357] |
Mon, 12 March 2018 06:00 |
 |
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
