Home » Developer & Programmer » Forms » ORA-302000 error with CLIENT_TEXT_IO.FOPEN  () 1 Vote
ORA-302000 error with CLIENT_TEXT_IO.FOPEN [message #187909] Wed, 16 August 2006 05:58 Go to next message
samyak.mishra
Messages: 6
Registered: August 2006
Junior Member
Hello ,
i am trying to read a file in my computer in forms 9i using CLIENT_TEXT_IO.FOPEN .. but whenever i run it i am getting the ora-302000 ..i checked the permissions and file name ... everything was in place... the fmx is deployed on Oracle Application Server 10g release 1 (9.0.4) ....
can anybody help me out of this...

Thanks in advance,
Sam
Re: ORA-302000 error with CLIENT_TEXT_IO.FOPEN [message #188135 is a reply to message #187909] Thu, 17 August 2006 04:15 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I googled 'ORA-302000' and found http://www.experts-exchange.com/Databases/Oracle/Q_20241109.html

Please post your code.

David
Re: ORA-302000 error with CLIENT_TEXT_IO.FOPEN [message #188320 is a reply to message #188135] Thu, 17 August 2006 23:50 Go to previous messageGo to next message
samyak.mishra
Messages: 6
Registered: August 2006
Junior Member
Hello ,


the files exists and all relevant permissions are also there ... the code is deployed on Oracle Application server 9.0.4 and webutil version used is 1.0.6 ....
i think this is something related to webutil....
please help on this as i am completely baffled by this error ...

here is my code ....

declare
f client_text_io.file_type;
begin
f := client_text_io.fopen('C:\test.txt', 'r');
end;

and this is the error that is coming in java console ....

java.lang.NullPointerException
at sun.io.Converters.getConverterClass(Unknown Source)
at sun.io.Converters.newConverter(Unknown Source)
at sun.io.ByteToCharConverter.getConverter(Unknown Source)
at java.io.InputStreamReader.<init>(Unknown Source)
at oracle.forms.webutil.file.FileFunctions.fopen (FileFunctions.java:413)
at oracle.forms.webutil.file.FileFunctions.getProperty(FileFunctions.java:188)
at oracle.forms.handler.UICommon.onGet(Unknown Source)
at oracle.forms.engine.Runform.onGetHandler(Unknown Source)
at oracle.forms.engine.Runform.processMessage(Unknown Source)
at oracle.forms.engine.Runform.processSet(Unknown Source)
at oracle.forms.engine.Runform.onMessageReal(Unknown Source)
at oracle.forms.engine.Runform.onMessage(Unknown Source)
at oracle.forms.engine.Runform.processEventEnd(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

2006-Aug-18 08:52:11.551 ERROR>WUC-15 [FileFunctions.fopen()] Unexpected error, Exception: java.lang.NullPointerException

Thanks in advance,
Sam

Re: ORA-302000 error with CLIENT_TEXT_IO.FOPEN [message #188814 is a reply to message #188320] Mon, 21 August 2006 16:10 Go to previous messageGo to next message
m_ashtiani
Messages: 27
Registered: August 2005
Location: Reno
Junior Member
WUC-15 means you did not install webutil properly.
check if you have

-- signed in your jar files.
-- formsweb.cfg variables, path , etc (note webutil env)


Re: ORA-302000 error with CLIENT_TEXT_IO.FOPEN [message #188821 is a reply to message #188814] Mon, 21 August 2006 20:47 Go to previous message
samyak.mishra
Messages: 6
Registered: August 2006
Junior Member
Hello ,
Thanks everyone ... the problem got solved when i re-compiled the webutil.pll and attached it to the form ...
now it is working fine ....

Thanks again,
Sam
Previous Topic: calendar
Next Topic: Display a record at for one time in the day
Goto Forum:
  


Current Time: Fri Sep 20 09:51:42 CDT 2024