PL/SQL (MOSC)

MOSC Banner

ORA-29283: invalid file operation on FOPEN because Windows file is encrypted

edited May 6, 2010 9:32AM in PL/SQL (MOSC) 5 commentsAnswered
I am using   11.1.0.7.0 - 64bit. If  I log on to my database server (Windows 2003 R2 64 bit) with the SAME id that oracle uses, and I encrypt a file, should my oracle stored procedures be able to access this file with utl_file? I can FOPEN successfully when the file is unencrypted. After I encrypt, I get: ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at "DIPUSER.GEN_KEY_FNC", line 20

P.S. I mistakenly made this a "Document"--can somebody delete it? 


 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center