DimPLSQLTable w/ TOracleDataSet
- Thread starter cosmini
- Start date
DimPLSQLTable has been added to the TOracleDataSet in 3.4.6, so you will need to upgrade.
------------------
Marco Kalter
Allround Automations
------------------
Marco Kalter
Allround Automations
thanks much Marco, upgrading to 3.4.6.3 did the trick however now I'm getting a different type of error:
"PLS-00418 array bind type must match pl/sql table row type." (on 8.1.6.1)
In my example, which works if called within Toad, I have:
type t_Sections is table of pls_integer index by binary_integer;
//changing pls_integer with integer yields 'no data'; pls_integer seems to yield correct results;
The Delphi section goes like this:
...
sections:variant;
...
DeclareVariable('sectionid',otInteger);
DimPLSQLTable('sectionid',wwdbGrid1.SelectedList.Count, 0);
...
Sections := VarArrayCreate([0, wwdbgrid1.SelectedList.Count-1], varVariant);
//I tried different types of var arrays but with no luck. The error occurs when I set active on the dataset (not on the SetVariable of the variant).
any suggestions?
thx much
[This message has been edited by cosmini (edited 20 October 2003).]
[This message has been edited by cosmini (edited 20 October 2003).]
[This message has been edited by cosmini (edited 20 October 2003).]
"PLS-00418 array bind type must match pl/sql table row type." (on 8.1.6.1)
In my example, which works if called within Toad, I have:
type t_Sections is table of pls_integer index by binary_integer;
//changing pls_integer with integer yields 'no data'; pls_integer seems to yield correct results;
The Delphi section goes like this:
...
sections:variant;
...
DeclareVariable('sectionid',otInteger);
DimPLSQLTable('sectionid',wwdbGrid1.SelectedList.Count, 0);
...
Sections := VarArrayCreate([0, wwdbgrid1.SelectedList.Count-1], varVariant);
//I tried different types of var arrays but with no luck. The error occurs when I set active on the dataset (not on the SetVariable of the variant).
any suggestions?
thx much
[This message has been edited by cosmini (edited 20 October 2003).]
[This message has been edited by cosmini (edited 20 October 2003).]
[This message has been edited by cosmini (edited 20 October 2003).]
Strange. What happens if you declare the variable as otFloat?
------------------
Marco Kalter
Allround Automations
------------------
Marco Kalter
Allround Automations
Can you send me a little demo project to reproduce this?
------------------
Marco Kalter
Allround Automations
------------------
Marco Kalter
Allround Automations
