I use CASE, and it works in most cases.
case
when length(field)>0
then xmltype(field).extract('//select[@id="programm"]/text()').getstringval()
else null
end"programm"
But in some lines showing is an error.
Error: ORA-06502:PL/SQL: numeric or value error: character string bufer too small ORA - 06512: at SYS.XMLTYPE,line 170
When an error occurs, the options field has the form:
<form> <text sbfield = "" id = "text" mandatory = "false" sbcomman ... </ form>
aplication connect error
aplication connect error
aplication connect error
...
the options field when there is no error looks like this:
<form> <text sbfield = "" id = "text" mandatory = "false" sbcomman ... </ form>
the options field contains about 20,000 characters.
DB Oracle 11.
Is it possible to fix this?