Ora-29283 error on 11g

Question

0.00/5 (No votes)

See more:

Is it possible to access a folder on my PC from oracle database? In other words database is not installed on my local machine and I have created a folder on my PC 'C:\LOB' where I want to save images retrieved from database, but it is returning an ora-29283 error: invalid file operation. I am sure that directory is created because I can see it in directories folder in my database. So what could be the problem? is it because folder is created on my PC and database is somewhere else? Below is my procedure:

SQL

CREATE OR REPLACE PROCEDURE BLOB_UPDATE (file_name in varchar) IS

    file_ref UTL_FILE.file_type;
    raw_max_size constant number := 32767;

 begin

   file_ref := UTL_FILE.fopen('MY_DIR', file_name, 'WB', raw_max_size);
   -- Here it stops working ! -- 
   ....
   utl_file.fclose(file_ref);

END BLOB_UPDATE;

What I have tried:

I have tried to create another directory but I still have the same problem

Posted 7-Nov-16 21:06pm

H.AL

Updated 7-Nov-16 22:59pm

Add a Solution

Comments

Richard MacCutchan 8-Nov-16 4:24am

Where is directory MY_DIR, and what is contained in file_name?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Accepted Answer · 2016-11-07T22:59:00

The database running on its server, which is not your computer (except in very rare cases).
That means that when you are writing in your SQL statement any part (c:\my_dir\my_file.txt) it is relative to the server and not to your computer...
You may use an UNC (\\my_computer\c_share\my_dir\my_file.txt), but it now opens a whole new problem of security...
So basically, even if it is possible, it is a very bad idea to directly save date from tables to files using SQL...
Do this:
1. Return the BLOB as any other data to your application
2. Save the BLOB data using standard - client side - techniques...