SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create the directory in the OS through PL/SQL

Levi PereiraNov 5 2010 — edited Nov 5 2010

Hi Gurus,

I am creating a procedure to automate the creation of external tables and directories Oracle (using Dynamic SQL).

I wonder if it is possible to create the directory in the OS through the Procedure.

As in SQL Plus
SQL> host mkdir /oracle/test

Thx,
Levi Pereira

This post has been answered by Saubhik Banerjee on Nov 5 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 3 2010

Added on Nov 5 2010

#pl-sql

9 comments

4,879 views