Home » Infrastructure » Windows » OO4O: AddTable's "ServerType" parameter
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
Previous Topic: query
Next Topic: Error While connecting ASP Page with Oracle 9i.
Goto Forum:
  


Current Time: Fri Nov 22 13:39:07 CST 2024