Passing data from TPlSqlTable into DataSet

[stef]

Hi All,

Is there a way how I can pass data from a PLSQLTable into a DataSet in CBuilder (Using Xe2) or in delphi.

Reason:
I needed data but to get this, I needed to steps. Else they have to wait for the data endless....

pls help

 

[Marco Kalter]

You can use a TMemoryDataSet and populate it from the PLSQLTable. Not sure if that covers your needs though.

 

[stef]

Hi Marco,

Maybe there is also a different way. What I actually need is to execute a Query and with that "resultSet" (all records) I want to start the next Query because with an ... in (21321,3213131,3131321,321) I am much faster then I am creating one big query, This result is then passed into a DBGrid.

Therefore I thought I can do this by a package, but the data passing then into the grid is not that easy.

All ideas are welcome

thx a lot

 

[Marco Kalter]

You can perhaps use a schema-level collection type instead of PL/SQL Table. See also:

http://www.oracle-developer.net/display.php?id=301