Re: ORA-28595 "Invalid DLL path" and external procedure

From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 13 Jun 2003 11:33:09 -0700
Message-ID: <130ba93a.0306131033.559264e8@posting.google.com>

"Pinto" <ucanmailme_at_india.com> wrote in message news:<bcco96$6o9$1_at_news.mch.sbs.de>...
> the path in create library seems to be case sensitive.
> I had a similar problem in 9i win2k. after lot of struggle, when i changed
> the case of creat library it worked fine :-)
> Pinto.
>

You sure about this? I never heard that the directory is case sensitive on windows environment. UNIX yes, not windows. The following in done on WinXP. I have a small c library that gives me GMT.

SQL> select * from user_libraries;

LIBRARY_NAME

FILE_SPEC

D STATUS
- -------
C1ORA
d:\oracle\ora92\lib\LibGet_Time.dll
Y VALID SQL> set serveroutput on
SQL> declare
  2 x date;
  3 begin
  4 universaltime(x);
  5 dbms_output.put_line(to_char(x,'ddmmyy hh24:mi:ss'));   6 end;
  7 /
130603 18:24:03

PL/SQL procedure successfully completed.

Change to upper case SQL> create or replace library c1ora as 'd:\oracle\ora92\lib\LIBGET_TIME.DLL'; 2 /

Library created.

SQL> set serveroutput on
SQL> declare
  2 x date;
  3 begin
  4 universaltime(x);
  5 dbms_output.put_line(to_char(x,'ddmmyy hh24:mi:ss'));   6 end;
  7 /
130603 18:25:06

PL/SQL procedure successfully completed.

Jusung Yang

Received on Fri Jun 13 2003 - 13:33:09 CDT