Home » SQL & PL/SQL » SQL & PL/SQL » CHMOD FROM A PLSQL?
CHMOD FROM A PLSQL? [message #622872] Mon, 01 September 2014 03:53 Go to next message
satishvaka
Messages: 3
Registered: July 2011
Junior Member
Hello, how I can run a chmod from a plsql block? if they can help me please ..


Regards

Satish Vaka
Re: CHMOD FROM A PLSQL? [message #622873 is a reply to message #622872] Mon, 01 September 2014 04:01 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why would you want to change access permissions to files and/or directories from PL/SQL?
Re: CHMOD FROM A PLSQL? [message #622874 is a reply to message #622872] Mon, 01 September 2014 04:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Also note that if you ever find how to do it, it would be on the SERVER not on the client (unless you use some client Forms PL/SQL).
Is this what you want?

Re: CHMOD FROM A PLSQL? [message #622875 is a reply to message #622872] Mon, 01 September 2014 04:33 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
satishvaka wrote on Mon, 01 September 2014 14:23
how I can run a chmod from a plsql block?


Exactly similar question was asked 2 years back in OTN https://community.oracle.com/thread/2404295?start=0&tstart=0
Re: CHMOD FROM A PLSQL? [message #623097 is a reply to message #622873] Thu, 04 September 2014 07:21 Go to previous messageGo to next message
satishvaka
Messages: 3
Registered: July 2011
Junior Member
Hi ,

Actually we are loading some text files which are placed in remote unix server using sqlloader. some times the files have CR/LF Issues.so we are tried to replacing that CR charter with blank and copying that data from that text file to another file and keeping that new file in same path where we are kept the old file.so Here Problem is the New file don't have write permissions for others. that' why we think that to create Java Procedure which will execute the chmod command on that file so that we will have file permissons for other
Re: CHMOD FROM A PLSQL? [message #623106 is a reply to message #623097] Thu, 04 September 2014 09:06 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>so we are tried to replacing that CR charter with blank and copying that data from that text file to another file
>and keeping that new file in same path where we are kept the old file.so

Why not fix the problem at the source; as opposed to apply the fix after the fact?
Just ensure the file is made with the desired protection mask to start with, then nothing else needs to be done.
Root cause & fix are external to Oracle & this thread is OFF TOPIC for this forum.
Previous Topic: Problem while Modifying column data type
Next Topic: Advantages of Order of Tables in "FROM " Clause
Goto Forum:
  


Current Time: Fri Mar 29 05:43:33 CDT 2024