Rascal
2008-02-28 15:23:06 UTC
Hi,
Can someone confirm the next problem (bug?)
I have a TSQLStoredProc pointing to a function inside an Oracle package (had
to specify it manually - drop down lists *nothing*). There are two
parameters: string input and cursor in/out.
When Activating the TSQLStoredProc from the IDE at design time everything
works as expected - Active can be set to true - just to test the controls.
When I add a TClientDataSet and connect it to the TSQLStoredProc over
TDataSetProvider and set Active to true - the first parameter is lost! And
therfore an error is displayed ("wrong number of parameters...")
In short, TClientDataset is dropping params from the Params list (self and
from the connected TSqlStoredProc ) populated by connecting the controls
together.
Delphi 2007 for Win32 UPD 3, Oracle 7.3
~rascal.
Can someone confirm the next problem (bug?)
I have a TSQLStoredProc pointing to a function inside an Oracle package (had
to specify it manually - drop down lists *nothing*). There are two
parameters: string input and cursor in/out.
When Activating the TSQLStoredProc from the IDE at design time everything
works as expected - Active can be set to true - just to test the controls.
When I add a TClientDataSet and connect it to the TSQLStoredProc over
TDataSetProvider and set Active to true - the first parameter is lost! And
therfore an error is displayed ("wrong number of parameters...")
In short, TClientDataset is dropping params from the Params list (self and
from the connected TSqlStoredProc ) populated by connecting the controls
together.
Delphi 2007 for Win32 UPD 3, Oracle 7.3
~rascal.