How to capture all the rows returned from a sql select query in CPO

[swaupadh]

Hi,

  I am executing an sql select query which returns multiple rows. I need to capture the values of each row to specific variables. How do I proceed.

Thanks,

Swati

[swaupadh]

Got the answer, we need to use the Read table From XML activity

[Von Jones]

The select activities  ("Select from Oracle," Select from SQL Server," etc.) against database already return tables.  Use one of the database adapters to do your select, and it will already be in a table form.  Just put your query in the select and identify the columns in your result table. The online help or the database adapter guides in the product documentation can help.