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