Database Directories are required to read/write to a filesystem location from plsql code.
Below is the syntax to create database directory
SQL> create directory PLSQL_DIR AS '/oratmp/code';
Directory created.
Grant Read/write privileges to Required Schema (e.g . APPS)
SQL> GRANT READ,WRITE ON DIRECTORY PLSQL_DIR TO APPS;
Grant succeeded.
Below is the syntax to create database directory
SQL> create directory PLSQL_DIR AS '/oratmp/code';
Directory created.
Grant Read/write privileges to Required Schema (e.g . APPS)
SQL> GRANT READ,WRITE ON DIRECTORY PLSQL_DIR TO APPS;
Grant succeeded.
No comments:
Post a Comment
Was this Post Helpful?
Feel free to suggest your opinions in the comments section!