Home » SQL & PL/SQL » SQL & PL/SQL » File permissions
File permissions [message #277360] Mon, 29 October 2007 14:58 Go to next message
apollo
Messages: 20
Registered: September 2007
Junior Member
If I have a procedure that opens and writes to a new file using PL/SQL (on a Linux box), how can I then change the read/write permissions of that file in the same procedure?
Thanks!
Re: File permissions [message #277362 is a reply to message #277360] Mon, 29 October 2007 15:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a Java procedure to do that.
See http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:952229840241

Regards
Michel
Re: File permissions [message #277368 is a reply to message #277362] Mon, 29 October 2007 15:49 Go to previous messageGo to next message
apollo
Messages: 20
Registered: September 2007
Junior Member
thanks Michel.
on a slightly related note, is there an easy way to execute a shell script from a pl/sql procedure?
Re: File permissions [message #277369 is a reply to message #277360] Mon, 29 October 2007 15:59 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
a SEARCH of this forum using "execute a shell script from a pl/sql procedure" generates a couple of dozen HITS.
Why does not any of them answer your question.
Previous Topic: Problems reducing a selection of grouped records
Next Topic: Need to insert values into table
Goto Forum:
  


Current Time: Thu Dec 08 16:37:26 CST 2016

Total time taken to generate the page: 0.05597 seconds