Search code examples
.netoracle-databaseclr

Oracle Deployment Wizard for .Net error


Oracle Deployment Wizard for .Net give me this error during Finish , can any one have any idea about this.

Directory ORACLECLRDIR does not exist

Thanks


Solution

  • There should be an oracle directory created :

    SQL> create or replace directory ORACLECLRDIR as '/home/oracle/utl_files';
    

    and access rights should be granted at least to your schema(HR) :

    SQL> grant read, write on directory ORACLECLRDIR to HR;