SQL & PL/SQL

Hello,

I used execute immediate ('create or replace directory TEST_DIR as ''/usr/tmp''') in my PLSQL package and when i run the package as a stand alone, it creates the directory and the files which i want to save in this directory as getting saved without any issue.

when i call the same package from a java programme, i don't get any error but the files are not getting saved in that directory and when i check the log, i get the error saying in "no directory with this name exists "

Basically, the directory is not being created when the package is being called from another application.

How to solve this issue?

Thanks for your help in advance.

PK