Naresh, February 18, 2021 - 11:50 am UTC
The Answer is correct but I have the huge string so I used getclobval() which is not working. Giving error message "PL/SQL: numeric or value error".
February 22, 2021 - 4:44 pm UTC
Please could you show us a complete example of what you're doing?
dbms_output.put_line(x.getstringval()); consuming time
Akshat, June 04, 2022 - 5:52 pm UTC
for above member function of XML element,
is there an alternative of this function or any other way around to get the faster printing in string format using dbms_output.put_line.
I am using x.getstringval() in my project and it is consuming lot of time to print the data on the console.
Please help me to improve the performance of the code.
June 07, 2022 - 3:11 am UTC
Can you give us a full example of what you're doing with some timings to show us the issue