Dear Members ,

I am reading file names from a textfile and saving the filecontent into the clob datatype , but when I am saving the file into the table using forms6i . It is throwing an error ORA-30200 .


declare

in_file Text_IO.File_Type;

linebuf varchar2(20);
nextfname varchar2(20);

begin

in_file := Text_IO.Fopen('c:\ramesh\filenames.txt', 'r');


LOOP

Text_IO.Get_Line(in_file, linebuf);
nextfname := linebuf;

---message(nextfname); I can see the file names in the file
--file name ca101690o1
-- sca11390o1

old_text_load(nextfname); //but here the ORA-30200 error is throwing any idea...

END LOOP;

EXCEPTION

WHEN no_data_found THEN

Text_IO.Put_Line('Closing the file...');

Text_IO.Fclose(in_file);

END;

I have seen in the metalink of oracle ,it is saying that if the filename is more than 8 chars in some versions of windows it will throw this error , but if it is win2000 it will not throw , but I am using Win2000 . If I am giving the parameters to the procedure thru SQLPLUS , the file is being inserted without complaining , Can any one send me a solution for this ORA-30200 .



Regards

Ramesh.M