RA-01008; Not all variables bound

[SteveQ]

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.

 

[Marco Kalter]

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

 

[DvH]

Thanxs for the solution.
This was the problem.

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?