Go up
How to SELECT XMLTYPE data with Perl DBD::Oracle?
| Subject: |
How to SELECT XMLTYPE data with Perl DBD::Oracle? |
| Author: |
Michel Cadot, France |
| Date: |
Aug 18, 2015, 15:40, 2776 days ago |
| Oracle info: |
Oracle: 10.2-11.2, Perl: 5.20.2, DBI: 1.633, DBD::Oracle: 1.74 |
| Message: |
You can simply select an XMLTYPE column in SQL*Plus like:
SQL> select WAREHOUSE_SPEC
2 from OE.WAREHOUSES
3 where WAREHOUSE_SPEC is not null and rownum = 1
4 /
WAREHOUSE_SPEC
--------------------------------------------------------
<?xml version="1.0"?>
<Warehouse>
<Building>Owned</Building>
<Area>25000</Area>
<Docks>2</Docks>
<DockType>Rear load</DockType>
<WaterAccess>Y</WaterAccess>
<RailAccess>N</RailAccess>
<Parking>Street</Parking>
<VClearance>10 ft</VClearance>
</Warehouse>
This is a shorcut for the more correct:
select W.WAREHOUSE_SPEC.getclobval() WAREHOUSE_SPEC
from OE.WAREHOUSES W
where WAREHOUSE_SPEC is not null and rownum = 1
/
Now without changing the first query into the second one, is it possible to get the XML string with Perl DBD::Oracle?
I find one page on the web saying "don't waste your time to search on the web, it is not possible" and another one saying "I succeeded to do it binding a variable with attribute SQLT_STR type" but he did not show the code.
I tried with many different types and failed.
You can find a sample of code at the following link, if you want to try by yourself.
http://www.orafaq.com/forum/t/198320/
Regards
Michel
|
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here