This forum is currently locked. You can't register or post questions at this time. (read more)

synchronisation XML files

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Guest

synchronisation XML files

Postby Guest » Mon Nov 01, 2004 6:09 pm

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...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

RE:synchronisation XML files

Postby Tim... » Mon Nov 01, 2004 6:09 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Guest

RE:synchronisation XML files

Postby Guest » Mon Nov 01, 2004 6:09 pm

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...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

RE:synchronisation XML files

Postby Tim... » Mon Nov 01, 2004 6:09 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 4 guests

cron