i have a big problem with the BFILE. I would like to insert into an Oracle DB an image, with BFILE Field.
I'm programming with JAVA and i wrote this lines:
query="INSERT INTO TestBFile VALUES (seqBFileId.NextVal,BFileName('c:\\JPG\\','BFile.j pg'))";
The problem is that I have an Exception:
ORA-22285: non-existent directory or file for GETLENGTH operation
What is the problem? I read that i have to put a Directory on the Server, but i don't know the path and the Server File System. What I could do to resolve my problem?
Please help me. Thank you so much... Have a nice day
Hi, and thak you for your reply.
I answer at your point.
1. i already have a directory in C. The path is c:\JPG. The problem is that i have to put \\ into the path, because i work from java code.
2. I don't understand the question : JPG in ORACLE. I don' have a JPG in oracle but only a directory under c:\ (==> c:\JPG).
3. I tried your code, but i have at the same problem.