Home » SQL & PL/SQL » SQL & PL/SQL » Loading external library
icon9.gif  Loading external library [message #260637] Mon, 20 August 2007 09:47 Go to next message
tatoge
Messages: 2
Registered: August 2007
Junior Member
On Oracle 9.2 and AIX, I try to use external procedures with PL/SQL. I follow the guidelines from this website (http://www.idevelopment.info/data/Oracle/DBA_tips/PL_SQL/PLSQL_1.shtml). I've correctly configured tnsnames.ora and listener.ora (notably with ENVS="EXTPROC_DLLS=ANY") relative to the oracle 9.2 security requirements.

So, I've created the library, then the procedure. But I am confronted with some rights issues :
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Permission denied

I am not the admin of the database, but apparently, I have already the rights for creating and executing libraries/procedures.
What's wrong ?
Thank you for your help.
Re: Loading external library [message #260641 is a reply to message #260637] Mon, 20 August 2007 10:01 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Does the Oracle user (ie the account which is running the Db executable) have permission to read the directory in which the external library is living?

Is the external library on the same machine as the Db?
Re: Loading external library [message #260642 is a reply to message #260641] Mon, 20 August 2007 10:07 Go to previous message
tatoge
Messages: 2
Registered: August 2007
Junior Member
Thank you, it was very simple.

The library was 777 but the parent directory had insufficient rights.
Previous Topic: Complex use of substring fucntion
Next Topic: Creating a Calendar (merged 3 topics)
Goto Forum:
  


Current Time: Sat Dec 10 14:50:01 CST 2016

Total time taken to generate the page: 0.07738 seconds