Dynamic SQL and DOA

[EVatnik]

Hi there,

I have a stored procedure that builds SQL statement and then retrieves records dynamicaly.
Does anybody know how to pass selected records or refer to a cursor produced by dynamic SQL using DOA components?

Thank you

 

[Marco Kalter]

This depends on what the procedure does with the dynamically created SQL statement. If it opens a cursor for the SQL text, then you can use a cursor variable. If it returns the SQL text, you can use it in a TOracleQuery or TOracleDataSet.

------------------
Marco Kalter
Allround Automations