PARAMETER PASSING TO ORACLE FROM VB

[Maricus]

Hi,
I am converting a vb6 application in MSSQL to be able to work in Oracle 9/10. The problem is that in VB/MSSQL, when a certain number of parameters are passed, MSSQL does not mind the order in which they are passed. MSSQL will be able to sort out the peramters. Also, it is possible to pass fewer parameters as the receiving MSSQL.
But..

In Oracle, the parmaters must be passed by VB in the same order and number as the way Oracle receives them.

The problem, the amount of work involved to rearrange procedures, functions and the VB will be too much work.

How can I work around this problem.

Maricus

 

[Thargy]

Maricus,

is it possible to declare a user-defined type with numerous properties, and then pass just the type to oracle? The procedure in question could then examine the type for its properties.

Just shooting in the dark, as this may not be possible.

Regards

Tharg

Grinding away at things Oracular