Ok.. Im new at this so be gentle..
Im doing this...
select xmltype(image.docxml_frm).extract('/Accident/Case/Diagram/text()').getStringVal()
from accident_image image
where case_num like '%SP%';
but Im getting this...
ora-06502 PL/SQL: numeric or value error: character string buffer too small
How do I declare the buffer larger? this is a clob field which contains xml ofcourse..
This is the way this table was handed to me. I plan on making a view from this xml file in the clob and query it with sql/oracle form.
good or bad idea?
Message was edited by:
Mark Reichman