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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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: 26766
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 Feb 06 15:25:34 CST 2025