6 Replies Latest reply on Jul 9, 2019 4:19 PM by Subramanyam Yalla-Oracle

    <!ORA-31020: The operation is not allowed, Reason: For security reasons, ftp and http access over XDB repository is not allowed on server side> <!ORA-06512: at "SYS.XMLTYPE", line 283> <!ORA-06512: at line 1> <!31020. 00000 -  "The operation is not allowe

    Subramanyam Yalla-Oracle

      I am trying to get task description as per below code from xml data file stored in temp_tab.

      select TaskDesc

          from  

              temp_tab , 

              xmltable( 

                  'task-description/taskdesc' 

                  passing xmltype(file_data,1) 

                  columns 

                      TaskDesc varchar2(500) path 'para')

       

      But I am getting error for below lines in xml file:

      <?xml version="1.0" encoding="UTF-8"?>

      <!DOCTYPE mpd SYSTEM "mpboe04.dtd" [

      <!ENTITY % w3centities PUBLIC "-//W3C//ENTITIES Combined Set//EN//XML" "http://www.w3.org/2003/entities/2007/w3centities.ent">

      %w3centities;

      <!ENTITY L97F75F52CB864789FD93FBD89119DFD SYSTEM "L97F75F52CB864789FD93FBD89119DFD.cgm" NDATA cgm>

       

      Error is:

      <!ORA-31020: The operation is not allowed, Reason: For security reasons, ftp and http access over XDB repository is not allowed on server side>

      <!ORA-06512: at "SYS.XMLTYPE", line 283>

      <!ORA-06512: at line 1>

      <!31020. 00000 -  "The operation is not allowed, Reason: %s">

      <!*Cause:    The operation attempted is not allowed>

      <!*Action:   See reason and change to a valid operation.>

       

      Please advise.