Hvordan transformeret jeg mit XML med et XSLT?
Jeg har trukket et DOMDocument ud af mine data ved at bruge XMLGen funktionaliteten. Mit problem er nu at jeg ikke ved hvordan jeg skal påføre min transformation med et XSLT, nogle der har en ide om hvad jeg skal gøre?Dette er koden jeg høvler afsted for at lave xml:
SELECT SYS_XMLGEN(
XMLConcat(
XMLElement("LOGIN",
XMLForest(SYSDATE AS "DTCLIENT",
'DEMO' AS "USERID",
'demo' AS "USERPASS",
'POCTEST_06' AS "ADMIN",
p_def_usr_id AS "APPID",
'07000' AS "APPVER")),
XMLElement("DATA",
XMLForest(p_cont_no AS "CONT_NO",
p_cont_id AS "CONT_ID",
p_name_1 AS "NAME_1",
p_name_2 AS "NAME_2",
p_cont_is_suppl AS "CONT_IS_SUPPL",
p_cont_is_cust AS "CONT_IS_CUST",
p_suppl_stat AS "SUPPL_STAT",
p_cust_stat AS "CUST_STAT",
p_country_id AS "COUNTRY_ID",
p_lang_id AS "LANG_ID",
p_suppl_pay_term_id AS "SUPPL_PAY_TERM_ID",
p_cust_pay_term_id AS "CUST_PAY_TERM_ID",
p_suppl_trans_term_id AS "SUPPL_TRANS_TERM_ID",
p_cust_trans_term_id AS "CUST_TRANS_TERM_ID",
p_suppl_deliv_term_id AS "SUPPL_DELIV_TERM_ID",
p_cust_deliv_term_id AS "CUST_DELIV_TERM_ID",
p_deliv_place AS "DELIV_PLACE",
p_creditor_no AS "CREDITOR_NO",
p_debtor_no AS "DEBTOR_NO",
p_vat_reg_no AS "VAT_REG_NO",
p_proc_hand_usr_id AS "PROC_HAND_USR_ID",
p_sale_hand_usr_id AS "SALE_HAND_USR_ID",
p_suppl_rating AS "SUPPL_RATING",
p_cust_rating AS "CUST_RATING",
p_suppl_cls_code_id AS "SUPPL_CLS_CODE_ID",
p_suppl_agent_no AS "SUPPL_AGENT_NO",
p_cust_agent_no AS "CUST_AGENT_NO",
p_suppl_cur_id AS "SUPPL_CUR_ID",
p_cust_cur_id AS "CUST_CUR_ID",
p_suppl_rem AS "SUPPL_REM",
p_cust_rem AS "CUST_REM",
p_clean_up AS "CLEAN_UP",
p_web_access AS "WEB_ACCESS",
p_homepage AS "HOMEPAGE",
p_def_date AS "DEF_DATE",
p_def_usr_id AS "DEF_USR_ID",
p_upd_date AS "UPD_DATE",
p_upd_usr_id AS "UPD_USR_ID"))),
xmlformat.createformat('MARSXML')).getstringval()
INTO v_xml_cont
FROM dual;
Hcordan får jeg et transformeret med et stylesheet