Throwing ORA-302000 error when reading from a file and inserting into CLOB
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 .
in_file := Text_IO.Fopen('c:\ramesh\filenames.txt', 'r');
nextfname := linebuf;
---message(nextfname); I can see the file names in the file
--file name ca101690o1
old_text_load(nextfname); //but here the ORA-30200 error is throwing any idea...
WHEN no_data_found THEN
Text_IO.Put_Line('Closing the file...');
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 .
Click Here to Expand Forum to Full Width