Hi folks

I'm testing DOA with a view to purchase and have come up against a problem which has already been raised in this forum - my problem is the suggested cures haven't worked.
I have a DatasetProvider feeding a ClientDataSet from an OracleDataSet. The OracleDataSet SQL has two parameters (a month and a year as 'To_Char..) and works fine.
My problem is that after running perfectly the first time the above error message appears when a second run with altered parameters is attempted.
The OracleDataSet is returning the correct number of rows but the ClientDataSet is retaining the original data, even after I refresh the dataset of the provider ('DataSetProvider1.DataSet.Refresh;')and 'FetchParams' and 'Execute' on the ClientDatSet.
This is new territory for me so if I'm making a really dumb newbie mistake could someone please put me on the right track and out of my misery?
BTW our Oracle version is 8.1.7.0 and I'm using D6 Enterprise.

The error implies that there are bind variable references in the SQL text (:var) that are not declared. In a 3-tier situation this usually implies that the Params of the TClientDataSet do not match these bind variable references. Can you verify this?

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

Thanxs for the solution.
This was the problem.

[quote]Originally posted by mkalter:
The error implies that there are bind variable references in the SQL text (:var) that are not declared. In a 3-tier situation this usually implies that the Params of the TClientDataSet do not match these bind variable references. Can you verify this?

[/quote]