473,509 Members | 2,863 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

XML DB Repository Update Contents

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.

Jul 19 '05 #1
0 1603

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
12796
by: Sonoman | last post by:
Hello all: What is wrong with my code? I want it to update the new text on the textbox on every iteration of my loop. But instead the textbox updates all info at the end of the loop. I also have...
1
2460
by: Bart Plessers \(artabel\) | last post by:
Hello, I am wondering if one could do following. I have a main frame with 3 subframes ("top", "left" and "contents") I have a link in the left frame, someting like: <a...
2
2128
by: (Pete Cresswell) | last post by:
I'm tasked with developing a enterprise-level metadata tool - starting yesterday and TB delivered by Jan 30th. Ridiculous as it may sound, there actually is some small chance of my deliverins...
2
1932
by: Chris Fink | last post by:
Any idea why the database table is not being updated with the contents of the excel file loaded into the dataset? Any help is appreciated! // load database table, shell only string cnString =...
0
1507
by: yenlin.liu | last post by:
Who is the owner of the ebXML Registry Repository? Since The ebXML Registry Repository stores many business profiles and business scenarios. Companies can upload/download data from the ebXML RR....
4
18258
by: rahatekarabhijeet | last post by:
Hi, I have seen that some modules which are available on CPAN are not listed in ActiveState repository. So those are not available to install by using ppm. I find out the way of adding adding...
2
2965
by: C_Kubie | last post by:
I have a populater listbox and I update the contents by running a different SQL statement via listbx.Rowsource ="<SQL statement>" The contents of the listbox changes but the form doesn't. ...
2
2888
by: hotflash | last post by:
Hi Master CroCrew, I found a good PURE ASP that will allow you to upload 10MB file to the server and the file contents such as Network, Author, Title, etc... will insert to MS Access at the same...
0
351
by: Athanasios Mantes | last post by:
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...
0
7237
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7137
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7347
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7416
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7506
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5062
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4732
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3218
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
1
779
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.