a proplem when create a directory
600930Aug 4 2008 — edited Aug 8 2008hi guys
i'd like to create a directory and load the files from it
but i got some errors as following
-----------------------------
SQL> create directory db2 as 'c:\az';
Directory created.
SQL> BEGIN
2 DBMS_XMLSCHEMA.registerSchema(
3 SCHEMAURL=>'http://homepagezz.com/Movies.xsd',
4 SCHEMADOC=>bfilename('db2','Movies.xsd'),
5 LOCAL =>false,
6 GENTYPES=>false,
7 GENTABLES=>FALSE,
8 CSID=>nls_charset_id('AL32UTF8'));
9 END;
10 /
BEGIN
*
ERROR at line 1:
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 635
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 127
ORA-06512: at line 2
--------------------------
so i'm wondering if u know the reason of this problem;