Home » SQL & PL/SQL » SQL & PL/SQL » pl sql to XML conversion (11g)
pl sql to XML conversion [message #631392] Tue, 13 January 2015 07:34 Go to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
Hi I have this package, This package generates an XML file and export it to various stores. But I have come across a scenario where in if the employee name is of a special character something like 'Rïçhàrd Bæcôn' the XML generates it as 'Richard B?con'. I have tried using htf.escape_sc() function.But still not getting the same format.I wan to display as 'Rïçhàrd Bæcôn' in XML as well. Can any one please help?

create or replace package body my_pkg as
    function get_emp RETURN T_XFORM_STRING
    is
    PRAGMA AUTONOMOUS_TRANSACTION;
    emp_data_string T_XFORM_STRING := T_XFORM_STRING();
    LINE_COUNTER NUMBER := 1;
    V_TEXT       VARCHAR2(4000) := NULL;
    V_ROWCNT NUMBER := 0;
    emp_rec emp_rec_type;
    begin
    SELECT count(*) into v_rowcnt FROM nbty_custom ;
    IF ( v_rowcnt > 0 ) THEN
    open emp_cur;
    fetch emp_cur
    bulk collect into
    emp_rec.emp_id,
    emp_rec.emp_name,
    emp_rec.emp_city;
    close emp_rec;
    FOR i IN 1..EMP_REC.EMP_ID.COUNT() LOOP
    begin
    select

    case
    when emp_rec.emp_id(i) in('001','002','003') then
    '    <Employee>        '||CHR(10)||
    '        <EmployeeID>'||EMP_REC.EMP_ID(i)||'</EmployeeID>'||chr(10)||
    '        <EmployeeName>'||EMP_REC.EMP_NAME(i)||'</EmployeeName>'||chr(10)||
    '        <EmployeeCity>'||EMP_REC.EMP_CITY(i)||'</EmployeeCity>'||chr(10)||
    '    </Employee>        '||CHR(10)||
    END INTO V_TEXT FROM DUAL;--emp_data_string.extend;
    emp_data_string(LINE_COUNTER) :=V_TEXT;
    LINE_COUNTER:=LINE_COUNTER+1;
    End;
    END LOOP;
    END IF;
    RETURN emp_data_string;
    END GET_EMP;
    END MY_PKG;  

*BlackSwan added {code} tags. Please do so yourself in the future.

[Updated on: Tue, 13 January 2015 07:43] by Moderator

Report message to a moderator

Re: pl sql to XML conversion [message #631393 is a reply to message #631392] Tue, 13 January 2015 07:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Do you have a data storage problem or a data presentation problem?
Does this problem manifest itself on every system?
Re: pl sql to XML conversion [message #631394 is a reply to message #631392] Tue, 13 January 2015 07:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals.

First can you select with SQL*Plus the correct value?
Copy and paste your session with one example which is correct or not correct.
Before read the above links.

Re: pl sql to XML conversion [message #631399 is a reply to message #631394] Tue, 13 January 2015 08:54 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
no I can't Select the value correctly

<EmployeeID>001</EmployeeID>
<EmployeeName>Richard B?con</EmployeeName>
<EmployeeCity>New York</EmployeeCity>

[Updated on: Tue, 13 January 2015 08:56]

Report message to a moderator

Re: pl sql to XML conversion [message #631400 is a reply to message #631399] Tue, 13 January 2015 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It doesn't seem to me that "B?con" is correct.

Please post as requested.

Re: pl sql to XML conversion [message #631401 is a reply to message #631399] Tue, 13 January 2015 09:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>no I can't Select the value correctly
Then it might not be stored in the database correctly.

modify the SQL below to match your environment & post both SQL & results back here

SELECT ASCIISRT(FOREIGN_COL) FROM XML_TABLE WHERE ID = 123;

above will show if the desired & correct character actually now resides in the DB.
Re: pl sql to XML conversion [message #631403 is a reply to message #631401] Tue, 13 January 2015 09:05 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
oops..!!
I looked it from another table...

Yes I am able to fetch the data correctly but why in d xml it is showing Richard B?con do I need to use some function like htf.escape_sc() ???
Re: pl sql to XML conversion [message #631405 is a reply to message #631403] Tue, 13 January 2015 09:27 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
This is because you didn't use proper encoding. In fact, it doesn't look like you didn't use any encoding at all. Add, for example:

<?xml version="1.0" encoding="ISO-8859-1"?>

SY.
Re: pl sql to XML conversion [message #631407 is a reply to message #631403] Tue, 13 January 2015 10:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Yes I am able to fetch the data correctly


So not tell, SHOW us and show us in the way we request.

Re: pl sql to XML conversion [message #631421 is a reply to message #631407] Wed, 14 January 2015 00:33 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
After selecting the data from Database it is seen as

<EmployeeID>001</EmployeeID>
<EmployeeName>Rïçhàrd Bæcôn</EmployeeName>
<EmployeeCity>New York</EmployeeCity>

I even used <?xml version="1.0" encoding="ISO-8859-1"?> while generating the xml but still I am getting the employee name as 'Richard B?con' when the XML is generated.
Re: pl sql to XML conversion [message #631423 is a reply to message #631421] Wed, 14 January 2015 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
After selecting


With which tool?

Re: pl sql to XML conversion [message #631426 is a reply to message #631423] Wed, 14 January 2015 01:06 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
SQL Developer ,Database Oracle 11g.
Re: pl sql to XML conversion [message #631427 is a reply to message #631426] Wed, 14 January 2015 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is your Oracle client character set?
What is your OS character set?
What is your database character set?
How do you execute your package? With SQL Developer?
What is T_XFORM_STRING?
How do you display T_XFORM_STRING or know the characters are wrong?
Re: pl sql to XML conversion [message #631431 is a reply to message #631427] Wed, 14 January 2015 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forgot: what is the statement you executed to get the result in your previous post?

Re: pl sql to XML conversion [message #631439 is a reply to message #631431] Wed, 14 January 2015 01:48 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
What is your Oracle client character set? AL32UTF8
What is your OS character set?
What is your database character set? AL32UTF8
How do you execute your package? With SQL Developer? this package is called via a .ksh file
What is T_XFORM_STRING? it is a type/Object

[code]create or replace
TYPE t_xform_string
AS TABLE OF VARCHAR2(4000);[code]

How do you display T_XFORM_STRING or know the characters are wrong? through the xml
Re: pl sql to XML conversion [message #631442 is a reply to message #631439] Wed, 14 January 2015 01:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
How do you execute your package? With SQL Developer? this package is called via a .ksh file


ksh can't call an Oracle package. What tool call it?

Quote:
How do you display T_XFORM_STRING or know the characters are wrong? through the xml


What tool shows you the xml?
From where the tool gets the xml? A file?
In this mater, how the file is generated? Post the code.


Re: pl sql to XML conversion [message #631461 is a reply to message #631442] Wed, 14 January 2015 02:41 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
The posted code was just a smaller version...

The actual code is as follows
please find the necessary files attached



[Edit MC: attached file removed at OP's request. It is useless to follow the topic.]

[Updated on: Thu, 15 January 2015 01:14] by Moderator

Report message to a moderator

Re: pl sql to XML conversion [message #631462 is a reply to message #631461] Wed, 14 January 2015 02:43 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
The entire package



[Edit MC: attached file removed at OP's request. It is useless to follow the topic.]

[Updated on: Thu, 15 January 2015 01:14] by Moderator

Report message to a moderator

Re: pl sql to XML conversion [message #631463 is a reply to message #631462] Wed, 14 January 2015 02:44 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
and the KSH file...I hope its more clearer now...



[Edit MC: attached file removed at OP's request. It is useless to follow the topic.]

[Updated on: Thu, 15 January 2015 01:14] by Moderator

Report message to a moderator

Re: pl sql to XML conversion [message #631466 is a reply to message #631463] Wed, 14 January 2015 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Not entirely, you didn't answer all my questions.

Re: pl sql to XML conversion [message #631467 is a reply to message #631463] Wed, 14 January 2015 02:47 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
The XML looks like this

  • Attachment: emp.png
    (Size: 84.28KB, Downloaded 699 times)
Re: pl sql to XML conversion [message #631471 is a reply to message #631466] Wed, 14 January 2015 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I summarize what I understand from your post:
1/ When you query the table from your PC using SQL Developer, you get what you want (which query?)
2/ When you generate a xml file from Unix and display this file (on your PC? which means you transfered it from Unix to your PC, which OS?) using Java Decompiler, you get a result you don't want

Did you in both case use the query from your ksh file? As I don't see the same code in all your files.

Re: pl sql to XML conversion [message #631474 is a reply to message #631471] Wed, 14 January 2015 03:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And post the result of BlackSwan's query (or the like).
Use SQL*PLus and copy and paste what you do and get.
Re: pl sql to XML conversion [message #631475 is a reply to message #631474] Wed, 14 January 2015 03:08 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
On running SELECT * FROM TABLE(cast(EXPORT_EMPLOYEE_PKG.funcExportEmployee(
P_STOREID =>'03456') AS T_XFORM_STRING));
I get the below on SQL Developer

"<?xml version="1.0" encoding="ISO-8859-1"?>
<EmployeeImport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="EmployeeImport.xsd"
Priority="0"
FillType="FullIncremental"
Version="1.0"
Batch="1"
CreationDate="2015-01-14T14:36:23.0Z">
"
" <Employee>
<ChangeType>UPS</ChangeType>
<EmployeeID>96217</EmployeeID>
<EmployeeFullName>Rïçhàrd Bæcôn</EmployeeFullName>
<EmployeeFirstName>Rïçhàrd</EmployeeFirstName>
<EmployeeLastName>Bæcôn</EmployeeLastName>
<EmployeeMiddleName></EmployeeMiddleName>
<EmployeeRole>Management</EmployeeRole>
<PartyID>66374</PartyID>
<StatusCode>1</StatusCode>
<EmployeeAccess>
<EmployeeLoginID>96217</EmployeeLoginID>
<AccessPassword>A6xnQhbz4Vx2HuGl4lXwZ5U2I8iziLRFnhP5eNfIRvQ=</AccessPassword>
<WorkGroupID>5</WorkGroupID>
<NewPasswordRequired>true</NewPasswordRequired>
<PasswordCreationDate>2015-01-14T14:36:23.0Z</PasswordCreationDate>
<PasswordHistory>
<PasswordHistoryEntry>
<PasswordCreationDate>2015-01-14T14:36:23.0Z</PasswordCreationDate>
<AccessPassword>A6xnQhbz4Vx2HuGl4lXwZ5U2I8iziLRFnhP5eNfIRvQ=</AccessPassword>
</PasswordHistoryEntry>
</PasswordHistory>
</EmployeeAccess>
<EmployeeCommisionPercentage>0</EmployeeCommisionPercentage>
<EmployeeType>0</EmployeeType>
<NumberDaysValid>-1</NumberDaysValid>
<EmployeeStoreOrHierarchyAssn>
<EmployeeStoreID>03456</EmployeeStoreID>
<EmployeeHierarchyAssn>
<NodeID>03456</NodeID>
<NodeType>store</NodeType>
<StoreGroupFunctionID>1</StoreGroupFunctionID>
</EmployeeHierarchyAssn>
</EmployeeStoreOrHierarchyAssn>
</Employee>
"
</EmployeeImport>
Re: pl sql to XML conversion [message #631477 is a reply to message #631475] Wed, 14 January 2015 03:15 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
For your question "Did you in both case use the query from your ksh file? As I don't see the same code in all your files."

The sequence is such that there is a job which calls the ksh file,when the ksh file runs if you see there is a call to orposempdnld.sql file this orposempdnld.sql file has
SELECT * FROM TABLE(cast(EXPORT_EMPLOYEE_PKG.funcExportEmployee(
P_STOREID =>'03456') AS T_XFORM_STRING)); which will call the function of the mentioned package when it gets the data it will combine all and display as above and generate this data into a XML file and jar it.
While creating the XML it is not showing what is expected.Since this XML has to be exported to other Database and since XML shows 'Richard B?con' the DB to where this XML needs to be exported will have 'Richard B?con' as Employee NAme which is not what I expect.

IS there any method by which I can just ignore this diacritic characters?Can something like replacing select replace('Rïçhàrd','ï','&' || 'iuml;') from dual; be of any use?

http://www.utexas.edu/learn/html/spchar.html
Re: pl sql to XML conversion [message #631478 is a reply to message #631475] Wed, 14 January 2015 03:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post the result of:
select unistr(column_value) from TABLE(cast(EXPORT_EMPLOYEE_PKG.funcExportEmployee(P_STOREID =>'03456') AS T_XFORM_STRING));

Re: pl sql to XML conversion [message #631480 is a reply to message #631478] Wed, 14 January 2015 03:23 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
Rïçhàrd
Re: pl sql to XML conversion [message #631482 is a reply to message #631480] Wed, 14 January 2015 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Question

Re: pl sql to XML conversion [message #631483 is a reply to message #631482] Wed, 14 January 2015 03:28 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
Which column value you exactly want?
If you want what the first name looks like after hitting the query you gave?
Its Rïçhàrd
Re: pl sql to XML conversion [message #631487 is a reply to message #631483] Wed, 14 January 2015 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

COLUMN_VALUE is the name of the column returned by TABLE function when a field name has not been given to the returned type (here T_XFORM_STRING).

Re: pl sql to XML conversion [message #631488 is a reply to message #631487] Wed, 14 January 2015 03:48 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
"<?xml version="1.0" encoding="ISO-8859-1"?>
<EmployeeImport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="EmployeeImport.xsd"
Priority="0"
FillType="FullIncremental"
Version="1.0"
Batch="1"
CreationDate="2015-01-14T15:17:55.0Z">
"
" <Employee>
<ChangeType>UPS</ChangeType>
<EmployeeID>96217</EmployeeID>
<EmployeeFullName>Rïçhàrd Bæcôn</EmployeeFullName>
<EmployeeFirstName>R&iuml;çhàrd</EmployeeFirstName>
<EmployeeLastName>Bæcôn</EmployeeLastName>
<EmployeeMiddleName></EmployeeMiddleName>
<EmployeeRole>Management</EmployeeRole>
<PartyID>66376</PartyID>
<StatusCode>1</StatusCode>
<EmployeeAccess>
<EmployeeLoginID>96217</EmployeeLoginID>
<AccessPassword>A6xnQhbz4Vx2HuGl4lXwZ5U2I8iziLRFnhP5eNfIRvQ=</AccessPassword>
<WorkGroupID>5</WorkGroupID>
<NewPasswordRequired>true</NewPasswordRequired>
<PasswordCreationDate>2015-01-14T15:17:55.0Z</PasswordCreationDate>
<PasswordHistory>
<PasswordHistoryEntry>
<PasswordCreationDate>2015-01-14T15:17:55.0Z</PasswordCreationDate>
<AccessPassword>A6xnQhbz4Vx2HuGl4lXwZ5U2I8iziLRFnhP5eNfIRvQ=</AccessPassword>
</PasswordHistoryEntry>
</PasswordHistory>
</EmployeeAccess>
<EmployeeCommisionPercentage>0</EmployeeCommisionPercentage>
<EmployeeType>0</EmployeeType>
<NumberDaysValid>-1</NumberDaysValid>
<EmployeeStoreOrHierarchyAssn>
<EmployeeStoreID>03456</EmployeeStoreID>
<EmployeeHierarchyAssn>
<NodeID>03456</NodeID>
<NodeType>store</NodeType>
<StoreGroupFunctionID>1</StoreGroupFunctionID>
</EmployeeHierarchyAssn>
</EmployeeStoreOrHierarchyAssn>
</Employee>
"
</EmployeeImport>
Re: pl sql to XML conversion [message #631489 is a reply to message #631488] Wed, 14 January 2015 03:51 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Once again, please read How to use [code] tags and make your code easier to read
Re: pl sql to XML conversion [message #631491 is a reply to message #631488] Wed, 14 January 2015 03:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is the result of unistr?
Post the same thing replacing unistr by dump.

Re: pl sql to XML conversion [message #631493 is a reply to message #631491] Wed, 14 January 2015 03:58 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
Yes It was through unistr

Now through dump it gives

Typ=1 Len=292: 60,63,120,109,108,32,118,101,114,115,105,111,110,61,34,49,46,48,34,32,101,110,99,111,100,105,110,103,61,34,73,83,79,45,56,56,53,57,45 ,49,34,63,62,10,60,69,109,112,108,111,121,101,101,73,109,112,111,114,116,32,120,109,108,110,115,58,120,115,105,61,34,104,116,116,112, 58,47,47,119,119,119,46,119,51,46,111,114,103,47,50,48,48,49,47,88,77,76,83,99,104,101,109,97,45,105,110,115,116,97,110,99,101,34,32, 120,115,105,58,110,111,78,97,109,101,115,112,97,99,101,83,99,104,101,109,97,76,111,99,97,116,105,111,110,61,34,69,109,112,108,111,121 ,101,101,73,109,112,111,114,116,46,120,115,100,34,10,32,32,32,32,80,114,105,111,114,105,116,121,61,34,48,34,32,10,32,32,32,32,70,105, 108,108,84,121,112,101,61,34,70,117,108,108,73,110,99,114,101,109,101,110,116,97,108,34,32,10,32,32,32,32,86,101,114,115,105,111,110, 61,34,49,46,48,34,32,10,32,32,32,32,66,97,116,99,104,61,34,49,34,32,10,32,32,32,32,67,114,101,97,116,105,111,110,68,97,116,101,61,34, 50,48,49,53,45,48,49,45,49,52,84,49,53,58,50,55,58,50,51,46,48,90,34,62,10
Typ=1 Len=1658: 32,32,32,32,60,69,109,112,108,111,121,101,101,62,32,32,32,32,32,32,32,32,10,32,32,32,32,32,32,32,32,60,67,104,97,110,103,101,84,121,1 12,101,62,85,80,83,60,47,67,104,97,110,103,101,84,121,112,101,62,10,32,32,32,32,32,32,32,32,60,69,109,112,108,111,121,101,101,73,68,6 2,57,54,50,49,55,60,47,69,109,112,108,111,121,101,101,73,68,62,10,32,32,32,32,32,32,32,32,60,69,109,112,108,111,121,101,101,70,117,10 8,108,78,97,109,101,62,82,195,175,195,167,104,195,160,114,100,32,66,195,166,99,195,180,110,60,47,69,109,112,108,111,121,101,101,70,11 7,108,108,78,97,109,101,62,10,32,32,32,32,32,32,32,32,60,69,109,112,108,111,121,101,101,70,105,114,115,116,78,97,109,101,62,82,239,23 1,104,224,114,100,60,47,69,109,112,108,111,121,101,101,70,105,114,115,116,78,97,109,101,62,10,32,32,32,32,32,32,32,32,60,69,109,112,1 08,111,121,101,101,76,97,115,116,78,97,109,101,62,66,195,166,99,195,180,110,60,47,69,109,112,108,111,121,101,101,76,97,115,116,78,97, 109,101,62,10,32,32,32,32,32,32,32,32,60,69,109,112,108,111,121,101,101,77,105,100,100,108,101,78,97,109,101,62,60,47,69,109,112,108, 111,121,101,101,77,105,100,100,108,101,78,97,109,101,62,10,32,32,32,32,32,32,32,32,60,69,109,112,108,111,121,101,101,82,111,108,101,6 2,77,97,110,97,103,101,109,101,110,116,60,47,69,109,112,108,111,121,101,101,82,111,108,101,62,10,32,32,32,32,32,32,32,32,60,80,97,114 ,116,121,73,68,62,54,54,51,55,57,60,47,80,97,114,116,121,73,68,62,10,32,32,32,32,32,32,32,32,60,83,116,97,116,117,115,67,111,100,101, 62,49,60,47,83,116,97,116,117,115,67,111,100,101,62,10,32,32,32,32,32,32,32,32,60,69,109,112,108,111,121,101,101,65,99,99,101,115,115 ,62,10,32,32,32,32,32,32,32,32,32,32,32,32,60,69,109,112,108,111,121,101,101,76,111,103,105,110,73,68,62,57,54,50,49,55,60,47,69,109, 112,108,111,121,101,101,76,111,103,105,110,73,68,62,10,32,32,32,32,32,32,32,32,32,32,32,32,60,65,99,99,101,115,115,80,97,115,115,119, 111,114,100,62,65,54,120,110,81,104,98,122,52,86,120,50,72,117,71,108,52,108,88,119,90,53,85,50,73,56,105,122,105,76,82,70,110,104,80 ,53,101,78,102,73,82,118,81,61,60,47,65,99,99,101,115,115,80,97,115,115,119,111,114,100,62,10,32,32,32,32,32,32,32,32,32,32,32,32,60, 87,111,114,107,71,114,111,117,112,73,68,62,53,60,47,87,111,114,107,71,114,111,117,112,73,68,62,10,32,32,32,32,32,32,32,32,32,32,32,32 ,60,78,101,119,80,97,115,115,119,111,114,100,82,101,113,117,105,114,101,100,62,116,114,117,101,60,47,78,101,119,80,97,115,115,119,111 ,114,100,82,101,113,117,105,114,101,100,62,10,32,32,32,32,32,32,32,32,32,32,32,32,60,80,97,115,115,119,111,114,100,67,114,101,97,116, 105,111,110,68,97,116,101,62,50,48,49,53,45,48,49,45,49,52,84,49,53,58,50,55,58,50,51,46,48,90,60,47,80,97,115,115,119,111,114,100,67 ,114,101,97,116,105,111,110,68,97,116,101,62,10,32,32,32,32,32,32,32,32,32,32,32,32,60,80,97,115,115,119,111,114,100,72,105,115,116,1 11,114,121,62,10,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,60,80,97,115,115,119,111,114,100,72,105,115,116,111,114,121,69,110,1 16,114,121,62,10,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,60,80,97,115,115,119,111,114,100,67,114,101,97,116,105,1 11,110,68,97,116,101,62,50,48,49,53,45,48,49,45,49,52,84,49,53,58,50,55,58,50,51,46,48,90,60,47,80,97,115,115,119,111,114,100,67,114, 101,97,116,105,111,110,68,97,116,101,62,10,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,60,65,99,99,101,115,115,80,97, 115,115,119,111,114,100,62,65,54,120,110,81,104,98,122,52,86,120,50,72,117,71,108,52,108,88,119,90,53,85,50,73,56,105,122,105,76,82,7 0,110,104,80,53,101,78,102,73,82,118,81,61,60,47,65,99,99,101,115,115,80,97,115,115,119,111,114,100,62,10,32,32,32,32,32,32,32,32,32, 32,32,32,32,32,32,32,60,47,80,97,115,115,119,111,114,100,72,105,115,116,111,114,121,69,110,116,114,121,62,10,32,32,32,32,32,32,32,32, 32,32,32,32,60,47,80,97,115,115,119,111,114,100,72,105,115,116,111,114,121,62,10,32,32,32,32,32,32,32,32,60,47,69,109,112,108,111,121 ,101,101,65,99,99,101,115,115,62,10,32,32,32,32,32,32,32,32,60,69,109,112,108,111,121,101,101,67,111,109,109,105,115,105,111
Typ=1 Len=17: 60,47,69,109,112,108,111,121,101,101,73,109,112,111,114,116,62
Re: pl sql to XML conversion [message #631499 is a reply to message #631493] Wed, 14 January 2015 04:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK, so now we know the data are correctly returned at sql and binary levels.
Now, we have to know if it is correct in the Unix spool file.
Post the result of:
od -xa EmployeeExport.xml


[Updated on: Wed, 14 January 2015 11:37]

Report message to a moderator

Re: pl sql to XML conversion [message #631502 is a reply to message #631499] Wed, 14 January 2015 04:53 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
How do I run this? No idea about linux
Re: pl sql to XML conversion [message #631504 is a reply to message #631502] Wed, 14 January 2015 04:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

On shell prompt, in the directory where there is the file.

Re: pl sql to XML conversion [message #631509 is a reply to message #631504] Wed, 14 January 2015 05:14 Go to previous messageGo to next message
saniya
Messages: 21
Registered: January 2015
Junior Member
Got It.

0000020 302e 2022 6e65 6f63 6964 676e 223d 5349
          .   0   "  sp   e   n   c   o   d   i   n   g   =   "   I   S
0000040 2d4f 3838 3935 312d 3f22 0a3e 453c 706d
          O   -   8   8   5   9   -   1   "   ?   >  nl   <   E   m   p
0000060 6f6c 6579 4965 706d 726f 2074 6d78 6e6c
          l   o   y   e   e   I   m   p   o   r   t  sp   x   m   l   n
0000100 3a73 7378 3d69 6822 7474 3a70 2f2f 7777
          s   :   x   s   i   =   "   h   t   t   p   :   /   /   w   w
0000120 2e77 3377 6f2e 6772 322f 3030 2f31 4d58
          w   .   w   3   .   o   r   g   /   2   0   0   1   /   X   M
0000140 534c 6863 6d65 2d61 6e69 7473 6e61 6563
          L   S   c   h   e   m   a   -   i   n   s   t   a   n   c   e
0000160 2022 7378 3a69 6f6e 614e 656d 7073 6361
          "  sp   x   s   i   :   n   o   N   a   m   e   s   p   a   c
0000200 5365 6863 6d65 4c61 636f 7461 6f69 3d6e
          e   S   c   h   e   m   a   L   o   c   a   t   i   o   n   =
0000220 4522 706d 6f6c 6579 4965 706d 726f 2e74
          "   E   m   p   l   o   y   e   e   I   m   p   o   r   t   .
0000240 7378 2264 200a 2020 5020 6972 726f 7469
          x   s   d   "  nl  sp  sp  sp  sp   P   r   i   o   r   i   t
0000260 3d79 3022 0a22 2020 2020 6946 6c6c 7954
          y   =   "   0   "  nl  sp  sp  sp  sp   F   i   l   l   T   y
0000300 6570 223d 7546 6c6c 6e49 7263 6d65 6e65
          p   e   =   "   F   u   l   l   I   n   c   r   e   m   e   n
0000320 6174 226c 200a 2020 5620 7265 6973 6e6f
          t   a   l   "  nl  sp  sp  sp  sp   V   e   r   s   i   o   n
0000340 223d 2e31 2230 200a 2020 4220 7461 6863
          =   "   1   .   0   "  nl  sp  sp  sp  sp   B   a   t   c   h
0000360 223d 2231 200a 2020 4320 6572 7461 6f69
          =   "   1   "  nl  sp  sp  sp  sp   C   r   e   a   t   i   o
0000400 446e 7461 3d65 3222 3130 2d35 3130 312d
          n   D   a   t   e   =   "   2   0   1   5   -   0   1   -   1
0000420 5433 3830 343a 3a36 3530 302e 225a 0a3e
          3   T   0   8   :   4   6   :   0   5   .   0   Z   "   >  nl
0000440 200a 2020 3c20 6d45 6c70 796f 6565 0a3e
         nl  sp  sp  sp  sp   <   E   m   p   l   o   y   e   e   >  nl
0000460 2020 2020 2020 2020 433c 6168 676e 5465
         sp  sp  sp  sp  sp  sp  sp  sp   <   C   h   a   n   g   e   T
0000500 7079 3e65 5055 3c53 432f 6168 676e 5465
          y   p   e   >   U   P   S   <   /   C   h   a   n   g   e   T
0000520 7079 3e65 200a 2020 2020 2020 3c20 6d45
          y   p   e   >  nl  sp  sp  sp  sp  sp  sp  sp  sp   <   E   m
0000540 6c70 796f 6565 4449 393e 3236 3731 2f3c
          p   l   o   y   e   e   I   D   >   9   6   2   1   7   <   /
0000560 6d45 6c70 796f 6565 4449 0a3e 2020 2020
          E   m   p   l   o   y   e   e   I   D   >  nl  sp  sp  sp  sp
0000600 2020 2020 453c 706d 6f6c 6579 4665 6c75
         sp  sp  sp  sp   <   E   m   p   l   o   y   e   e   F   u   l
0000620 4e6c 6d61 3e65 ef52 68e7 72e0 2064 e642
          l   N   a   m   e   >   R   o   g   h   `   r   d  sp   B   f
0000640 f463 3c6e 452f 706d 6f6c 6579 4665 6c75
          c   t   n   <   /   E   m   p   l   o   y   e   e   F   u   l
0000660 4e6c 6d61 3e65 200a 2020 2020 2020 3c20
          l   N   a   m   e   >  nl  sp  sp  sp  sp  sp  sp  sp  sp   <
0000700 6d45 6c70 796f 6565 6946 7372 4e74 6d61
          E   m   p   l   o   y   e   e   F   i   r   s   t   N   a   m
0000720 3e65 ef52 68e7 72e0 3c64 452f 706d 6f6c
          e   >   R   o   g   h   `   r   d   <   /   E   m   p   l   o
0000740 6579 4665 7269 7473 614e 656d 0a3e 2020
          y   e   e   F   i   r   s   t   N   a   m   e   >  nl  sp  sp
0000760 2020 2020 2020 453c 706d 6f6c 6579 4c65
         sp  sp  sp  sp  sp  sp   <   E   m   p   l   o   y   e   e   L
0001000 7361 4e74 6d61 3e65 e642 f463 3c6e 452f
          a   s   t   N   a   m   e   >   B   f   c   t   n   <   /   E
0001020 706d 6f6c 6579 4c65 7361 4e74 6d61 3e65
          m   p   l   o   y   e   e   L   a   s   t   N   a   m   e   >
0001040 200a 2020 2020 2020 3c20 6d45 6c70 796f
         nl  sp  sp  sp  sp  sp  sp  sp  sp   <   E   m   p   l   o   y
0001060 6565 694d 6464 656c 614e 656d 3c3e 452f
          e   e   M   i   d   d   l   e   N   a   m   e   >   <   /   E
0001100 706d 6f6c 6579 4d65 6469 6c64 4e65 6d61
          m   p   l   o   y   e   e   M   i   d   d   l   e   N   a   m
0001120 3e65 200a 2020 2020 2020 3c20 6d45 6c70
          e   >  nl  sp  sp  sp  sp  sp  sp  sp  sp   <   E   m   p   l
0001140 796f 6565 6f52 656c 4d3e 6e61 6761 6d65
          o   y   e   e   R   o   l   e   >   M   a   n   a   g   e   m
0001160 6e65 3c74 452f 706d 6f6c 6579 5265 6c6f
          e   n   t   <   /   E   m   p   l   o   y   e   e   R   o   l
0001200 3e65 200a 2020 2020 2020 3c20 6150 7472
          e   >  nl  sp  sp  sp  sp  sp  sp  sp  sp   <   P   a   r   t
0001220 4979 3e44 3437 3838 3c31 502f 7261 7974
          y   I   D   >   7   4   8   8   1   <   /   P   a   r   t   y
0001240 4449 0a3e 2020 2020 2020 2020 533c 6174
          I   D   >  nl  sp  sp  sp  sp  sp  sp  sp  sp   <   S   t   a
0001260 7574 4373 646f 3e65 3c31 532f 6174 7574
          t   u   s   C   o   d   e   >   1   <   /   S   t   a   t   u
0001300 4373 646f 3e65 200a 2020 2020 2020 3c20
          s   C   o   d   e   >  nl  sp  sp  sp  sp  sp  sp  sp  sp   <
0001320 6d45 6c70 796f 6565 6341 6563 7373 0a3e
          E   m   p   l   o   y   e   e   A   c   c   e   s   s   >  nl
0001340 2020 2020 2020 2020 2020 2020 453c 706d
         sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp   <   E   m   p
0001360 6f6c 6579 4c65 676f 6e69 4449 393e 3236
          l   o   y   e   e   L   o   g   i   n   I   D   >   9   6   2
0001400 3731 2f3c 6d45 6c70 796f 6565 6f4c 6967
          1   7   <   /   E   m   p   l   o   y   e   e   L   o   g   i
0001420 496e 3e44 200a 2020 2020 2020 2020 2020
          n   I   D   >  nl  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp
0001440 3c20 6341 6563 7373 6150 7373 6f77 6472
         sp   <   A   c   c   e   s   s   P   a   s   s   w   o   r   d
0001460 413e 7836 516e 6268 347a 7856 4832 4775
          >   A   6   x   n   Q   h   b   z   4   V   x   2   H   u   G
0001500 346c 586c 5a77 5535 4932 6938 697a 524c
          l   4   l   X   w   Z   5   U   2   I   8   i   z   i   L   R
0001520 6e46 5068 6535 664e 5249 5176 3c3d 412f
          F   n   h   P   5   e   N   f   I   R   v   Q   =   <   /   A
0001540 6363 7365 5073 7361 7773 726f 3e64 200a
          c   c   e   s   s   P   a   s   s   w   o   r   d   >  nl  sp
0001560 2020 2020 2020 2020 2020 3c20 6f57 6b72
         sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp   <   W   o   r   k
0001600 7247 756f 4970 3e44 3c35 572f 726f 476b
          G   r   o   u   p   I   D   >   5   <   /   W   o   r   k   G
0001620 6f72 7075 4449 0a3e 2020 2020 2020 2020
          r   o   u   p   I   D   >  nl  sp  sp  sp  sp  sp  sp  sp  sp
0001640 2020 2020 4e3c 7765 6150 7373 6f77 6472
         sp  sp  sp  sp   <   N   e   w   P   a   s   s   w   o   r   d
0001660 6552 7571 7269 6465 743e 7572 3c65 4e2f
          R   e   q   u   i   r   e   d   >   t   r   u   e   <   /   N
0001700 7765 6150 7373 6f77 6472 6552 7571 7269
          e   w   P   a   s   s   w   o   r   d   R   e   q   u   i   r
0001720 6465 0a3e 2020 2020 2020 2020 2020 2020
          e   d   >  nl  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp
0001740 503c 7361 7773 726f 4364 6572 7461 6f69
          <   P   a   s   s   w   o   r   d   C   r   e   a   t   i   o
0001760 446e 7461 3e65 3032 3531 302d 2d31 3331
          n   D   a   t   e   >   2   0   1   5   -   0   1   -   1   3
0002000 3054 3a38 3634 303a 2e35 5a30 2f3c 6150
          T   0   8   :   4   6   :   0   5   .   0   Z   <   /   P   a
0002020 7373 6f77 6472 7243 6165 6974 6e6f 6144
          s   s   w   o   r   d   C   r   e   a   t   i   o   n   D   a
0002040 6574 0a3e 2020 2020 2020 2020 2020 2020
          t   e   >  nl  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp
0002060 503c 7361 7773 726f 4864 7369 6f74 7972
          <   P   a   s   s   w   o   r   d   H   i   s   t   o   r   y
0002100 0a3e 2020 2020 2020 2020 2020 2020 2020
          >  nl  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp
0002120 2020 503c 7361 7773 726f 4864 7369 6f74
         sp  sp   <   P   a   s   s   w   o   r   d   H   i   s   t   o
0002140 7972 6e45 7274 3e79 200a 2020 2020 2020
          r   y   E   n   t   r   y   >  nl  sp  sp  sp  sp  sp  sp  sp
0002160 2020 2020 2020 2020 2020 2020 3c20 6150
         sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp   <   P   a
0002200 7373 6f77 6472 7243 6165 6974 6e6f 6144
          s   s   w   o   r   d   C   r   e   a   t   i   o   n   D   a
0002220 6574 323e 3130 2d35 3130 312d 5433 3830
          t   e   >   2   0   1   5   -   0   1   -   1   3   T   0   8
0002240 343a 3a36 3530 302e 3c5a 502f 7361 7773
          :   4   6   :   0   5   .   0   Z   <   /   P   a   s   s   w
0002260 726f 4364 6572 7461 6f69 446e 7461 3e65
          o   r   d   C   r   e   a   t   i   o   n   D   a   t   e   >
0002300 200a 2020 2020 2020 2020 2020 2020 2020
         nl  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp
0002320 2020 2020 3c20 6341 6563 7373 6150 7373
         sp  sp  sp  sp  sp   <   A   c   c   e   s   s   P   a   s   s
0002340 6f77 6472 413e 7836 516e 6268 347a 7856
          w   o   r   d   >   A   6   x   n   Q   h   b   z   4   V   x
0002360 4832 4775 346c 586c 5a77 5535 4932 6938
          2   H   u   G   l   4   l   X   w   Z   5   U   2   I   8   i
0002400 697a 524c 6e46 5068 6535 664e 5249 5176
          z   i   L   R   F   n   h   P   5   e   N   f   I   R   v   Q
0002420 3c3d 412f 6363 7365 5073 7361 7773 726f
          =   <   /   A   c   c   e   s   s   P   a   s   s   w   o   r
0002440 3e64 200a 2020 2020 2020 2020 2020 2020
          d   >  nl  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp
0002460 2020 3c20 502f 7361 7773 726f 4864 7369
         sp  sp  sp   <   /   P   a   s   s   w   o   r   d   H   i   s
0002500 6f74 7972 6e45 7274 3e79 200a 2020 2020
          t   o   r   y   E   n   t   r   y   >  nl  sp  sp  sp  sp  sp
0002520 2020 2020 2020 3c20 502f 7361 7773 726f
         sp  sp  sp  sp  sp  sp  sp   <   /   P   a   s   s   w   o   r
0002540 4864 7369 6f74 7972 0a3e 2020 2020 2020
          d   H   i   s   t   o   r   y   >  nl  sp  sp  sp  sp  sp  sp
0002560 2020 2f3c 6d45 6c70 796f 6565 6341 6563
         sp  sp   <   /   E   m   p   l   o   y   e   e   A   c   c   e
0002600 7373 0a3e 2020 2020 2020 2020 453c 706d
          s   s   >  nl  sp  sp  sp  sp  sp  sp  sp  sp   <   E   m   p
0002620 6f6c 6579 4365 6d6f 696d 6973 6e6f 6550
          l   o   y   e   e   C   o   m   m   i   s   i   o   n   P   e
0002640 6372 6e65 6174 6567 303e 2f3c 6d45 6c70
          r   c   e   n   t   a   g   e   >   0   <   /   E   m   p   l
0002660 796f 6565 6f43 6d6d 7369 6f69 506e 7265
          o   y   e   e   C   o   m   m   i   s   i   o   n   P   e   r
0002700 6563 746e 6761 3e65 200a 2020 2020 2020
          c   e   n   t   a   g   e   >  nl  sp  sp  sp  sp  sp  sp  sp
0002720 3c20 6d45 6c70 796f 6565 7954 6570 303e
         sp   <   E   m   p   l   o   y   e   e   T   y   p   e   >   0
0002740 2f3c 6d45 6c70 796f 6565 7954 6570 0a3e
          <   /   E   m   p   l   o   y   e   e   T   y   p   e   >  nl
0002760 2020 2020 2020 2020 4e3c 6d75 6562 4472
         sp  sp  sp  sp  sp  sp  sp  sp   <   N   u   m   b   e   r   D
0003000 7961 5673 6c61 6469 2d3e 3c31 4e2f 6d75
          a   y   s   V   a   l   i   d   >   -   1   <   /   N   u   m
0003020 6562 4472 7961 5673 6c61 6469 0a3e 2020
          b   e   r   D   a   y   s   V   a   l   i   d   >  nl  sp  sp
0003040 2020 2020 2020 453c 706d 6f6c 6579 5365
         sp  sp  sp  sp  sp  sp   <   E   m   p   l   o   y   e   e   S
0003060 6f74 6572 724f 6948 7265 7261 6863 4179
          t   o   r   e   O   r   H   i   e   r   a   r   c   h   y   A
0003100 7373 3e6e 200a 2020 2020 2020 2020 2020
          s   s   n   >  nl  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp
0003120 3c20 6d45 6c70 796f 6565 7453 726f 4965
         sp   <   E   m   p   l   o   y   e   e   S   t   o   r   e   I
0003140 3e44 3330 3534 3c36 452f 706d 6f6c 6579
          D   >   0   3   4   5   6   <   /   E   m   p   l   o   y   e
0003160 5365 6f74 6572 4449 0a3e 2020 2020 2020
          e   S   t   o   r   e   I   D   >  nl  sp  sp  sp  sp  sp  sp
0003200 2020 2020 2020 453c 706d 6f6c 6579 4865
         sp  sp  sp  sp  sp  sp   <   E   m   p   l   o   y   e   e   H
0003220 6569 6172 6372 7968 7341 6e73 0a3e 2020
          i   e   r   a   r   c   h   y   A   s   s   n   >  nl  sp  sp
0003240 2020 2020 2020 2020 2020 2020 2020 4e3c
         sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp   <   N
0003260 646f 4965 3e44 3330 3534 3c36 4e2f 646f
          o   d   e   I   D   >   0   3   4   5   6   <   /   N   o   d
0003300 4965 3e44 200a 2020 2020 2020 2020 2020
          e   I   D   >  nl  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp
0003320 2020 2020 3c20 6f4e 6564 7954 6570 733e
         sp  sp  sp  sp  sp   <   N   o   d   e   T   y   p   e   >   s
0003340 6f74 6572 2f3c 6f4e 6564 7954 6570 0a3e
          t   o   r   e   <   /   N   o   d   e   T   y   p   e   >  nl
0003360 2020 2020 2020 2020 2020 2020 2020 2020
         sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp
0003400 533c 6f74 6572 7247 756f 4670 6e75 7463
          <   S   t   o   r   e   G   r   o   u   p   F   u   n   c   t
0003420 6f69 496e 3e44 3c31 532f 6f74 6572 7247
          i   o   n   I   D   >   1   <   /   S   t   o   r   e   G   r
0003440 756f 4670 6e75 7463 6f69 496e 3e44 200a
          o   u   p   F   u   n   c   t   i   o   n   I   D   >  nl  sp
0003460 2020 2020 2020 2020 2020 3c20 452f 706d
         sp  sp  sp  sp  sp  sp  sp  sp  sp  sp  sp   <   /   E   m   p
0003500 6f6c 6579 4865 6569 6172 6372 7968 7341
          l   o   y   e   e   H   i   e   r   a   r   c   h   y   A   s
0003520 6e73 0a3e 2020 2020 2020 2020 2f3c 6d45
          s   n   >  nl  sp  sp  sp  sp  sp  sp  sp  sp   <   /   E   m
0003540 6c70 796f 6565 7453 726f 4f65 4872 6569
          p   l   o   y   e   e   S   t   o   r   e   O   r   H   i   e
0003560 6172 6372 7968 7341 6e73 0a3e 2020 2020
          r   a   r   c   h   y   A   s   s   n   >  nl  sp  sp  sp  sp
0003600 2f3c 6d45 6c70 796f 6565 0a3e 3c0a 452f
          <   /   E   m   p   l   o   y   e   e   >  nl  nl   <   /   E
0003620 706d 6f6c 6579 4965 706d 726f 3e74 000a
          m   p   l   o   y   e   e   I   m   p   o   r   t   >  nl nul
0003637

[Updated on: Wed, 14 January 2015 06:43] by Moderator

Report message to a moderator

Re: pl sql to XML conversion [message #631511 is a reply to message #631509] Wed, 14 January 2015 07:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK, so the data that are in the file are no more in UTF8 but in another character set but seems to be correct.
What is your NLS_LANG environment parameter value on Unix?
Can you attach the xml file to check at our side.

And, please, format your post as per How to use [code] tags and make your code easier to read as it has been repeated to you.

[Updated on: Wed, 14 January 2015 07:01]

Report message to a moderator

Re: pl sql to XML conversion [message #631512 is a reply to message #631511] Wed, 14 January 2015 07:12 Go to previous messageGo to previous message
saniya
Messages: 21
Registered: January 2015
Junior Member
NLS_LANG is not set on Linux

Also XML files cannot be attached here Sad

[Updated on: Wed, 14 January 2015 07:41]

Report message to a moderator

Previous Topic: SQL query for a project scheduler
Next Topic: How to calculate in percent in sql query?
Goto Forum:
  


Current Time: Fri Mar 29 07:08:50 CDT 2024