Lost Params: TOraStoredProc + TClientDataSet over TDataSetProvider

zarko · Post by **zarko** » Fri 29 Feb 2008 14:30

Hi,

Delphi 2007 for Win 32. Oracle 7.3.

I'm trying to use a TOraStoredProc with one string input and one cursor input/output parameter.

When only the TOraSession and TOraStoredProc are used I am able to "Activate" the stored proc at design time.

When I connect a TDataSetProvider and a TClientDataSet I'm only able to "Activate" the client data set ONCE.

The second time it errors: "ORA-01008 not all variables bound".

Plus: the TORAStoredProc now only lists one (cursor) parameter.

Plus: the OraStoredProc dialog is now disabled - I cannot change any of parameter values (the input one).

Any ideas?

-zarko

Plash · Post by **Plash** » Mon 03 Mar 2008 09:07

When you open TClientDataSet component, it copies output and input/output parameters to its Params property. But input parameters are not copied. When you open the TClientDataSet component next time, the parameters from its Param property are used. As a result the problem occurs.
You should clear Params property of TClientDataSet each time before you open it.