Re: dynamic number of xsql:query tags in a xsql file

On Thu, 22 Aug 2002, Alexander.Wohrer_at_cern.ch wrote:
> Hello!
>
> I want to create <xsql:query> tags dynamicly, depending
> on the number of things I want to check
>
> Tried it with:
> <xsql:include-owa>
> BEGIN system.dbsec.service_report('{@service}'); END;
> </xsql:include-owa>
>
> and get back a lot of <xsql:query> tags with the right statements in
> it, but it seems the are not processed any more and stayed unchangend!

XSQL isn't going to execute output of queries.

What you might be able to do is write these to a file using the UTL_FILE package of Oracle and then in a subsequent xsql tag, include-xsql that file.

I haven't done this, but it might work.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.