Hey Vick,
Outstanding! Hehe.
Partyyyyyyy! Hehe.
Have a great Day!
-----Original Message-----
From: msawant
[mailto:oracledba-ezmlmshield-x14909103.[Email address protected]
Sent: Wednesday, October 10, 2007 8:38 AM
To: LazyDBA Discussion
Subject: RE: How to Execute OS commands in Win 2003 x64
Hi Ed,
You are right by stating the "trying to load the external //
library dynamically".
Based on the "*Action: Check the stacked error (if any) for more
details. //" we got the info that Oracle 64bit, was looking for a
MSVCRT.dll, and that file was in the path, so the problem was tough to
find.
On doing a search for a file with that name, the result were a
lot of files.
The solution was: 'Win 2003 x64' had amongst others, three
folders in the C:\WINNT folder, viz. SYSTEM, SYSTEM32, and SysWOW64.
SYSTEM is an empty folder,
SYSTEM32 contains the 64 bit files, and
SysWOW64 contains the 32 bit files.
We applied the MSVCRT.dll file from the SYSTEM32 folder and it
worked fine.
vick
-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x17235021.[Email address protected]
Sent: Wednesday, October 10, 2007 3:18 AM
To: LazyDBA Discussion
Subject: RE: How to Execute OS commands in Win 2003 x64
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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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