| Update an xml element in oracle 10gr1 without using Oracle XDB ? [message #588623] |
Thu, 27 June 2013 03:05  |
 |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
