Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- p_x xmltype := xmltype(
- '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
- <policyInput>
- <policyHolder>
- <birthDate>1988-06-12</birthDate>
- <gender>S</gender>
- <nationalIdentificationNumber>111222333477</nationalIdentificationNumber>
- <personName>ASDF</personName>
- <personSurname>TESTF</personSurname>
- <personType>OBČAN</personType>
- <personTypeInsurance2Id>5</personTypeInsurance2Id>
- <vatRegistered>Y</vatRegistered>
- </policyHolder>
- </policyInput>');
- l_bday VARCHAR2(100);
- l_gender VARCHAR2(100);
- l_nid VARCHAR2(100);
- l_pname VARCHAR2(100);
- l_psname VARCHAR2(100);
- l_ptype VARCHAR2(100);
- l_ptid VARCHAR2(10);
- l_vatreg VARCHAR2(2);
- BEGIN
- SELECT xt.*
- INTO
- l_bday
- , l_gender
- , l_nid
- , l_pname
- , l_psname
- , l_ptype
- , l_ptid
- , l_vatreg
- FROM xmltable(
- 'policyInput/policyHolder'
- passing p_x
- columns
- birthDate VARCHAR2(100) PATH 'birthDate',
- gender VARCHAR2(100) PATH 'gender',
- nationalIdentificationNumber VARCHAR2(100) PATH 'nationalIdentificationNumber',
- personName VARCHAR2(100) PATH 'personName',
- personSurname VARCHAR2(100) PATH 'personSurname',
- personType VARCHAR2(100) PATH 'personType',
- personTypeInsurance2Id VARCHAR2(100) PATH 'personTypeInsurance2Id',
- vatRegistered VARCHAR2(2) PATH 'vatRegistered'
- ) xt;
- INSERT INTO OSEBA VALUES (
- l_bday
- , l_gender
- , l_nid
- , l_pname
- , l_psname
- , l_ptype
- , l_ptid
- , l_vatreg);
- DBMS_OUTPUT.put_line(l_bday);
- DBMS_OUTPUT.put_line(l_gender);
- DBMS_OUTPUT.put_line(l_nid);
- DBMS_OUTPUT.put_line(l_pname);
- DBMS_OUTPUT.put_line(l_psname);
- DBMS_OUTPUT.put_line(l_ptype);
- DBMS_OUTPUT.put_line(l_ptid);
- DBMS_OUTPUT.put_line(l_vatreg);
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement