Well, well, well!
It's msawant! Hehe. How have you been. Below is info from Oracle
metalink.


06520, 00000, "PL/SQL: Error loading external library"
// *Cause: An error was detected by PL/SQL trying to load the external
// library dynamically.
// *Action: Check the stacked error (if any) for more details.
//

This error indicates that the shared library is not placed in the

correct location.

Have a great Day!





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: msawant
[mailto:oracledba-ezmlmshield-x70954649.[Email address protected]
Sent: Tuesday, October 09, 2007 6:26 PM
To: LazyDBA Discussion
Subject: How to Execute OS commands in Win 2003 x64

How would I execute a Windows 2003 x64 OS command in Oracle 64 bits, for
eg. a batch file execution from within a PL SQL procedure?

We have a:
FUNCTION fn_system( i_sCmd IN VARCHAR2 )
RETURN BINARY_INTEGER IS
EXTERNAL LIBRARY clib
NAME "system";

Any OS command I execute, is within the fn_system
('f:\getMeAnswer.bat');
This was working fine until we migrated from "Oracle and Win 32 bit" to
"Oracle and Win 64 bits".

I get the error:
Ora 06520 : PL/SQL: Error loading external library
and Ora 06522 : Unable to load dll





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page