Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2007
    Posts
    1

    Unanswered: Sql Related Problem

    I m trying to access a file residing inside a directory but the oracle10g server is not been able to access the file inside the directory...

    the code is ...

    CREATE or replace DIRECTORY xml_src_dir AS '\\kvm165\D:\xml_dir';

    declare
    inpfile xmltype;

    begin
    --CREATE or replace DIRECTORY xml_src_dir AS 'D:\xml_dir';
    inpfile := XMLType(bfilename('XML_SRC_DIR','MfsEnv.xml'),
    nls_charset_id('AL32UTF8'));
    INSERT INTO staging_table(MSG_ID,TOPIC,XML_MSG,PARSE_FLAG,COMM ENTS)
    VALUES(gen_num.nextval,extractValue(inpfile,'//Topic/text()'),inpfile,'n','NOTPARSED');
    end;

    The error msg is...


    12:15:24 PM
    12:15:24 PM *** SCRIPT START : SessionCOTT@ORCL(1) 12/20/2007 12:15:24 PM ***
    12:15:24 PM Start SQL Editor Execution ...
    12:15:24 PM Processing ...
    12:15:26 PM declare
    12:15:26 PM *
    12:15:26 PM ORA-22288: file or LOB operation FILEOPEN failed
    12:15:26 PM The network path was not found.
    12:15:26 PM ORA-06512: at "SYS.DBMS_LOB", line 523
    12:15:26 PM ORA-06512: at "SYS.XMLTYPE", line 287
    12:15:26 PM ORA-06512: at line 6
    12:15:26 PM *** Script stopped due to error ***
    12:15:26 PM *** SCRIPT END : SessionCOTT@ORCL(1) 12/20/2007 12:15:26 PM ***
    12:15:26 PM End SQL Editor Execution


    plz reply me ASAP....

    have a nice day...

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    but the oracle10g server
    This is the MySQL forum, you'll get a better response to Oracle questions on the Oracle forum.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Moved to Oracle topic
    George
    Home | Blog

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Did you grant the required privileges to the user? Is it able to perform read and/or write operations on the directory?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •