Skip to Main Content

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!

how can i create and drop a directory

kama021Jun 11 2009 — edited Jun 12 2009
i have a program that will create and drop a directory. this is my code

i no you can create a direcotry like this

create or replace directory Signature as '/sig/images/oo1'; this works fine

now i want to do this in the code

declare a variable
strDir as Varchar2(100);

strDir :='/sig/images/oo1' ;

create or replace directory Signature as strDir
is this possible
This post has been answered by Solomon Yakobson on Jun 12 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2009
Added on Jun 11 2009
31 comments
1,545 views