How to execute select query from pl/sql that is greater than 4000 character
594403Aug 11 2009 — edited Aug 12 2009Hi,
I have a requirement to execute select sql query from pl/sql that will be greater than 4000 characters. How can I do that in pl/sql?
The select sql job here is to get id from a table where it matches certain existsNode xpath expression of a xmltype column. The existsNode xpath expression can go beyond 4k. When I tried executing that I get the error saying ORA-01704: string literal too long.
For example I have a table results_table where the columns are id and XMLType.
results_table(id number, attr_diff xmltype).
Any ideas on how can I solve this issue?