synchronisation XML files

[Guest]

Hi,
i've a 9i database and i want to concept a synchronisation between users and database who takes XML-files to send updated datas to the database.
The idea is that there is a web form which import and export XML-files.
And there are more then one user who do this.
First of all i want to know can Oracle handle this?
What happends if the first user sends his XML-file to the database->the procedure to parse the file runs and the next one want to send his XMLfile to the database?
Do you know an available concept?
The second question:
I've a complex XML-Schema and when i try to extract the XML-file i get this error message:
ORA-29400: Data Cartridge-Fehler
ORA-00600: Interner Fehlercode, Argumente: [invalid_mem_type], [0], [], [], [],
[], [], []
I read in an other forum it is neccesasary to upgrade to 9.2.0.2.0 or 9.2.0.3.0.
Is this right?
And which patchset should i take?
Thanks in advance.
With best regards
Nicole

[Tim...]

Hi.

I'm really not sure what you mean, but I gather it's something to do with auditing. If your web server logs in via a single oracle user then there is now way it can know who the user is by default. You can however set the client_identifier of the session using the dbms_session package and this will allow you to audit the interactions either using the Oracle auditing ot a custom trigger solution. Alternatively you can use the dbms_application_info package to write information to the v$session view allowing you to do a similar thing.

Also, when you talk about uploading XML aer you talking via XML DB or your own solution?

As I say, I'm not really suer what you are talking about so I don't know how helpful I can be.

Cheers

Tim...

[Guest]

Hi,
I try to explain the situation again. It's difficult because know the project is in the design phase.I have a XML-Schema which is registered in the Database and procedures which extract and export a XML-file and update the DB.
I also have two Java Applets which copy the files between server and client.
The user interface should be a web form.
Now i need the knowledge how Oracle handles this if two or more users starts the procedure to import/export a XML-file.Is it possible that they can make it
simultaneously?
And what do you think about the upgrade?
Thanks in advance.
With best regards
Nicole

[Tim...]

Hi.

I'm still not totally sure I understand, but here goes:

1) The procedures you call to load the data must also accept user parameter which will allow you to record who did what.

2) The load is transactional so the first person to load the file will have their data overwritten by the second person to load the file unless you perform some form of validation ot log historical records.

Both of these things are manual tasks for you to program.

Cheers

Tim...