Oracle might be trying to access the 32 bit library still. I know we
have had some issues with that on our AIX servers.

I think the problem was the LD_LIBRARY_PATH was being used before the
LD_LIBRARY_PATH_64 environment variable. I don't know what the solution
is for Windows, but I remember all we needed to do was change the order
they were defined somewhere... I just can't remember where.

So maybe that's a little helpful?

Scott

-----Original Message-----
From: msawant
[mailto:oracledba-ezmlmshield-x70954649.[Email address protected]
Sent: Tuesday, October 09, 2007 3: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