Invalid File Id Error
585634Jun 28 2007 — edited Jul 2 2007Hello,
I am using shell script to run a set of sql scripts againts a 9.2 db.
When the script tries to write a file to a specified location it gives the following error,
DECLARE
*
ERROR at line 1:
ORA-29282: invalid file ID
ORA-06512: at "SYS.UTL_FILE", line 714
ORA-06512: at line 395
ORA-29280: invalid directory path
But if I run the same set of queries in a different box it runs successfully with now issues. We have verified that both versions of Oracle and AIX are one and the same. the directories to which it is trying to write has the same permissions too. Also did a comparison of the objects and didn't see any difference.
Any help in this regard would be greatly appreciated.
Thanks,
Jubil