Hi, I need to generate an xml file from a stored procedure, and retriving it by a java resultset.
My database is Oracle 10 that, as far as I know, supports this kind of features.
I have few questions:
1) is it possible to perform such operation "on the fly", or it is necessary to write the file first and then read it? I mean, for ex. call the procedure and get file content as string.
2) is it performing? Of course assuming that the query that generates the dataset is.
3) In the examples I found, the procedure generates always a temp table. Is it possible to skip this step?
Thanks in advance