-
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 .
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|