OraFAQ Forum: Forms » Ora-302000

Home » Developer & Programmer » Forms » Ora-302000

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: Ora-302000 [message #73210 is a reply to message #73208]

Wed, 03 March 2004 02:34

Mahesh Rajendran
Messages: 10572
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

Report message to a moderator

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;

Report message to a moderator

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....

Report message to a moderator

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

Report message to a moderator

Re: Ora-302000 [message #556192 is a reply to message #327357]

Thu, 31 May 2012 15:47

luisen22
Messages: 1
Registered: May 2012

Junior Member

that solve my problem, thanks

Report message to a moderator

Previous Topic:	COMMENT BUTTON Set_ICO_Property
Next Topic:	Problem with forms debugging

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 08:09:45 CDT 2013

Total time taken to generate the page: 0.12540 seconds