Home » Developer & Programmer » JDeveloper, Java & XML » Update an xml element in oracle 10gr1 without using Oracle XDB ? (ORACLE 10 GR1 / AIX )
Update an xml element in oracle 10gr1 without using Oracle XDB ? [message #588623] Thu, 27 June 2013 03:05 Go to next message
jelencik
Messages: 8
Registered: May 2013
Location: TOULOUSE
Junior Member
Hi,

i would like to update an XML element without using the function APPENDCHILDXML or INSERTCHILDXML because they are not available in Oracle 10GR1.
In my database, Oracle XDB is not installed.
The following query fail with the following error : ORA-00904: "INSERTCHILDXML" : identificateur non valide

update scl_profile
set profile_data =
insertChildXML(profile_data,'/exportImportMarcheCriteria','colonnesExport',
XMLType('<colonnesExport>ENTETE_GESTIONNAIRES_AUTORISES</colonnesExport>'))
where profile_xmltype =
'fr.mipih.marches.marche.criteres.ExportImportMarcheCriteria'
and profile_type =
'eMagh2.MRGS.AccesMarche.ListeMarche.Export.OptionsExportImport';

Column profile_data content the following informations :
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<exportImportMarcheCriteria>
<colonnesExport>ENTETE_CODE_MARCHE</colonnesExport>
<colonnesExport>ENTETE_LIBELLE</colonnesExport>
<colonnesExport>ENTETE_ALOTTI</colonnesExport>
<colonnesExport>ENTETE_TYPE_SUIVI</colonnesExport>
<colonnesExport>ENTETE_TYPE_MARCHE</colonnesExport>
<colonnesExport>ENTETE_CATEGORIE</colonnesExport>
<colonnesExport>ENTETE_MODE_PASSATION</colonnesExport>
<colonnesExport>ENTETE_REF_ACCORD_CADRE</colonnesExport>
<colonnesExport>ENTETE_NATURE_ACHAT</colonnesExport>
<colonnesExport>ENTETE_RECONDUCTIBLE</colonnesExport>
<colonnesExport>ENTETE_MONTANT_CHIFFRE</colonnesExport>
<colonnesExport>ENTETE_MARCHE_COMPLEMENTAIRE</colonnesExport>
<colonnesExport>ENTETE_MARCHE_MIXTE</colonnesExport>
<colonnesExport>ENTETE_PRIX_VARIABLE</colonnesExport>
<colonnesExport>ENTETE_GROUPEMENT_ACHAT</colonnesExport>
<colonnesExport>ENTETE_GROUPEMENT_ENTREPRISE</colonnesExport>
<colonnesExport>ENTETE_TAUX_MAX_REVISION_PRIX</colonnesExport>
<colonnesExport>ENTETE_REFERENT</colonnesExport>
<colonnesExport>ENTETE_CODE_DGM</colonnesExport>
<colonnesExport>ENTETE_DATE_ENGAGEMENT</colonnesExport>
<colonnesExport>ENTETE_AVIS_PRE_INFO</colonnesExport>
<colonnesExport>ENTETE_DATE_CONSULTATION</colonnesExport>
<colonnesExport>ENTETE_NUM_CONSULTATION</colonnesExport>
<colonnesExport>ENTETE_DATE_AVIS_CAO</colonnesExport>
<colonnesExport>ENTETE_DATE_NOTIFICATION</colonnesExport>
<colonnesExport>ENTETE_DATE_DEPOT_PREFECTURE</colonnesExport>
<colonnesExport>ENTETE_DATE_APPROBATION</colonnesExport>
<colonnesExport>ENTETE_DATE_DEBUT_ETABLISSEMENT_PRIX</colonnesExport>
<colonnesExport>ENTETE_MOIS_MISE_EN_OEUVRE</colonnesExport>
<colonnesExport>ENTETE_INDICE_CALCUL</colonnesExport>
<colonnesExport>ENTETE_BLOC_NOTE</colonnesExport>
<colonnesExport>ENTETE_DATE_1ER_MANDAT</colonnesExport>
<colonnesExport>ENTETE_NUM_1ER_MANDAT</colonnesExport>
<colonnesExport>ENTETE_GESTIONNAIRES_AUTORISES</colonnesExport>
<colonnesExport>LOT_NUM</colonnesExport>
<colonnesExport>LOT_LIBELLE</colonnesExport>
<colonnesExport>LOT_BLOC_NOTE</colonnesExport>
<colonnesExport>LOT_TYPE_SUIVI</colonnesExport>
<colonnesExport>FOURNISSEUR_NUM</colonnesExport>
<colonnesExport>FOURNISSEUR_RAISON_SOCIALE</colonnesExport>
<colonnesExport>FEM_QUALITE</colonnesExport>
<colonnesExport>FEM_BLOC_NOTE</colonnesExport>
<colonnesExport>PERIODE_DEBUT_VALIDITE</colonnesExport>
<colonnesExport>PERIODE_FIN_VALIDITE</colonnesExport>
<colonnesExport>PERIODE_DATE_RENOUVELLEMENT</colonnesExport>
<colonnesExport>PERIODE_MONTANT_INI_HT</colonnesExport>
<colonnesExport>PERIODE_MONTANT_INI_TTC</colonnesExport>
<colonnesExport>PERIODE_MONTANT_MIN_HT</colonnesExport>
<colonnesExport>PERIODE_MONTANT_MIN_TTC</colonnesExport>
<colonnesExport>PERIODE_MONTANT_MAX_HT</colonnesExport>
<colonnesExport>PERIODE_MONTANT_MAX_TTC</colonnesExport>
<colonnesExport>PERIODE_SEUIL_ALERTE</colonnesExport>
<colonnesExport>PERIODE_DEPASSEMENT_AUTORISE</colonnesExport>
<colonnesExport>PERIODE_CODE_COORDONNEES_BANCAIRES</colonnesExport>
<colonnesExport>PERIODE_CAUTION_BANCAIRE</colonnesExport>
<colonnesExport>PERIODE_TAUX_RETENU_GARANTIE</colonnesExport>
<colonnesExport>PERIODE_MIN_FRANCO_PORT</colonnesExport>
<colonnesExport>PERIODE_MONTANT_MIN_COMMANDE</colonnesExport>
<colonnesExport>PERIODE_MANDATEMENT_PRIORITAIRE</colonnesExport>
<colonnesExport>PERIODE_CODE_DELAI_PAIEMENT</colonnesExport>
<colonnesExport>PERIODE_TRANSFERT</colonnesExport>
<colonnesExport>PERIODE_BLOC_NOTE</colonnesExport>
<colonnesExport>PERIODE_NOTE1</colonnesExport>
<colonnesExport>PERIODE_NOTE2</colonnesExport>
<colonnesExport>PERIODE_NOTE3</colonnesExport>
<colonnesExport>PERIODE_NOTE4</colonnesExport>
<colonnesExport>PERIODE_NOTE5</colonnesExport>
<colonnesExport>AVENANT_NUM</colonnesExport>
<colonnesExport>AVENANT_LIBELLE</colonnesExport>
<colonnesExport>AVENANT_DATE</colonnesExport>
<colonnesExport>AVENANT_MONTANT_HT</colonnesExport>
<colonnesExport>AVENANT_MONTANT_TTC</colonnesExport>
<colonnesExport>REVISION_DATE</colonnesExport>
<colonnesExport>REVISION_MONTANT_HT</colonnesExport>
<colonnesExport>REVISION_MONTANT_TTC</colonnesExport>
</exportImportMarcheCriteria>



If i try to use the package DBMS_XMLDOM, i have the following error :
ORA-06550: Ligne 3, colonne 11 :
PLS-00201: l'identificateur 'DBMS_XMLDOM.DOMDOCUMENT' doit etre declare
ORA-06550: Ligne 3, colonne 11 :
PL/SQL: Item ignored
I think it's because ORACLE XDB component is not installed in my database.


Re: Update an xml element in oracle 10gr1 without using Oracle XDB ? [message #588635 is a reply to message #588623] Thu, 27 June 2013 04:15 Go to previous message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is not installed then you can't use the XML functions.
So you have to use the good oldies: substr, replace, instr, concatenate...

Regards
Michel
Previous Topic: Validate only if updating the record
Next Topic: XML Publisher Reports
Goto Forum:
  


Current Time: Wed Sep 17 16:38:15 CDT 2014

Total time taken to generate the page: 0.10218 seconds