From: mantesat@mail.ntua.gr   
      
   I am looking for a way to update the contents of a resource in the   
   Oracle XMLDB Repository.   
      
   I am trying to write a stored procedure (PL/SQL or Java) that will   
   create a new version on a Resource and fill the created version's   
   contents with data of my choice. So far  I have found the following code   
   for updating resource contents   
      
   begin   
       chackout();   
     update resource_view set   
   res=updateXML(res,'/Resource/Contents/*','Test Data')   
     where any_path='/public/test1.txt';   
       checkin();   
   end;   
      
   But the above code does not work (The contents of the last version   
   remain the same with the previous verion). I have also tried getting an   
   oracle blob through java using   
      
   XDB.DBMS_XDB_VERSION.GetContentsBlobByResID(resid_type); and write to it   
   using   
   Java and BLOB.getBinaryOutputStream();   
      
   This also does not work, (the loop that writes to the stream is rolling   
   but the data do not change)   
      
   Is there a way I can avoid using FTP or HTTP PUT to update the contents   
   of a resource? Any help would be greatly appreciated.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)