Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating physical opertaing system directory with Oracle
Hi Pinaki,
You could use a java stored procedure or a C external procedure and then call either from PL/SQL. There are many security risks with this though - you should avoid exposing operating system commands to PL/SQL or SQL as this can be exploited especially if your database is accessible remotely. There are many papers about security and Oracle on my website http://www.petefinnigan.com/orasec.htm.
Kind regards
Pete
In article <96eccafc.0311040116.4481cc36_at_posting.google.com>, Pinaki
<bpinaki123_at_indiatimes.com> writes
>Hi,
> Is there any way through packages or anything that I can create
>physical operating system directory at a specified path.Suppose, I
>want to create a directory(physical not logical) "ABC" at a specified
>path(D:\Personal\ABC). How can this be done through PL/SQL.
>
>Thanks in advance
>
>Pinaki
-- Pete Finnigan email:pete_at_petefinnigan.com Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details.Received on Tue Nov 04 2003 - 05:14:14 CST