Want to create a directory in a PL/SQL procedure. If I don't consider the variable in the string to create the directory, it worked. However I have to consider the variable. For example,
v_str varchar2(6) := 'cat1';
v_sqltx := 'create or replace directory WK_DIR as ''c:\temp\''||v_str';
execute immediate (v_sqltx );
It did not work. Can any gurus offer some advice?