OO4O: AddTable's "ServerType" parameter [message #100954] |
Wed, 03 March 2004 03:41 |
Mirko Klotz
Messages: 1 Registered: March 2004
|
Junior Member |
|
|
Hi,
I have a problem concerning OO4O and the OraParameters collection: The "ServerType" parameter included in "AddTable" method does not work correctly. Let me give you an example:
First I want to add a OraParamArray to the OraParameters collection using the following method:
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
objOracle.OraDatabase.Parameters.AddTable "test", ORAPARM_INPUT, ORATYPE_NUMBER, 100
</BLOCKQUOTE>
With this command, I'm adding an input-parameter table called "test" with the Oracle datatype "NUMBER" and a size of 100 cells.
This works ok so far. But then, when I try to access the datatype via
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
Debug.Print objOracle.OraDatabase("test").ServerType
</BLOCKQUOTE>
I always get a 0 (=zero) as datatype. But I would expect a value of 2, because the type constant "ORATYPE_NUMBER", that I had given to the AddTable method, is 2 (see file ORACLE_BASEORACLE_HOMEoo4ooraconst.txt if you don't believe me).
Now I want to know: Is this just a bug or did I make a mistake?
Regards,
Mirko Klotz
|
|
|