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.
I just like the helpful information you provide in your articles
For the reason that the admin of this site is working, no uncertainty very quickly it will be renowned, due to its quality contents.
I appreciate you sharing this blog post. Thanks Again. Cool.
This is my first time pay a quick visit at here and i am really happy to read everthing at one place
Great information shared.. really enjoyed reading this post thank you author for sharing this post .. appreciated