Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PARAMETER PASSING TO MSSQL & ORACLE

Status
Not open for further replies.
Maricus

Maricus

Programmer
Mar 9, 2001
41
KE

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
 
Status
Not open for further replies.

Similar threads

Swi
  • Question
Printer.Print to PDF 1
Replies
16
Views
257
Swi
Swi
sal21
  • Question
I can't find the routine to download the image file anymore
Replies
1
Views
142
strongm
strongm
sal21
  • Locked
  • Question
how to send SMS via free API or other service
Replies
2
Views
462
strongm
strongm
BigTG
  • Question
Converting an old XP VB6 program to run on Windows 7 & Windows 10
Replies
5
Views
381
vb5prgrmr
vb5prgrmr
2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top