I

No, there are no standard methods or properties for this. Perhaps a memory dataset component exists that has this functionality and can be loaded from the TOracleDataSet (or any TDataSet descendant)?

Thank you for your advice.I

Although I have never tried, You can use
Delphi's standard TClientDataSet Component.
Using it's LoadFromFile/SaveToFile method,
you can load and save a dataset to/from an xml file.

Yes, yesterday night I was thinking about it and this morning I've tried it, but doesn't work. I don't know how to connect the TOracleDataSet to TClientDataSet. The procedure Assing doesn't go with TOracleDataSet. Using TVirtualTable is simpler than Delphi's component. The only inconvenient I find is the format of the exported file: it's not xml, which is very compatible by now.

If you connect the TOracleDataSet to TClientDataSet, you have to use TDataSetProvider Component, too.

The relation figure among these components is the following:

Oracle Sever -> TOracleSession -> TOracleDataSet -> TDataSetProvider(dataset property) -> TClientDataSet(providername property) -> TDataSource -> Delphi DB Controls

If you know how to use TClientDataSet in detail, please look at Delphi help or look for it in the web sites.

>>Using TVirtualTable is simpler than Delphi's component. The only inconvenient I find is the format of the exported file: it's not xml, which is very compatible by now.
I think how to use TClientDataSet is simlper than you think.

Thank you, I'll try it. Although I find using DOA without any other component is very easy, I realize that TClientDataSet and TDataSetProvider components give you more posibilities. Next project I'll use this method, because my actual project is too big to change all the data modules.

>I realize that TClientDataSet and >TDataSetProvider components give you more >posibilities
yes, I think so. TClientDataSet has a lot of useful functionality(local sorting, filterling, aggregating, grouping, master-detail relation and so on) and makes the developing database-software easier.It's great component but if you use a lot of TClientDataSet's functionality, you should the latest version of Delphi as possible as you can because the older Delphi version(5,6・・) has some bugs.

If you use these Delphi Version, you should confirm before you use TClientDataSet with your projects.

Some bugs are listed in
www.distribucon.com/midasbug/

Have a good time with TClientDataSet.