Stored procedures with out parameters misplace return values

[JeremyMarshall]

Having a SP with in and out params results in the return values in the wrong place.

Passing the out params in first fixes it but it shouldn't really matter...

import teradata
import argparse
from collections import ChainMap

parser = argparse.ArgumentParser(description="TEST callproc)", formatter_class=argparse.ArgumentDefaultsHelpFormatter)
parser.add_argument("server", help="?")
parser.add_argument("username", help="?")
parser.add_argument("password", help="Don't do this at home as the password will be visible")
parser.add_argument("-l", "--log", action='store_true', default=False, help="turn on logging stuff")

arguments = parser.parse_args()

udaExec = teradata.UdaExec (appName="HelloWorld", version="1.0", logConsole=arguments.log)

param_boilerplate =  {'USEINTEGRATEDSECURITY':'N', 'AUTHENTICATION': 'LDAP', 'method':'odbc'}

conn_parms = ChainMap(param_boilerplate, {'system':arguments.server, 'username':arguments.username, 'password':arguments.password,'queryBands':{'Name':'TEST'}})
session = udaExec.connect(**conn_parms)

params = (
    teradata.OutParam("o_value"),
    teradata.InOutParam(0, "i_search_type"),
    teradata.InOutParam('Name', "i_name")
)
results = session.callproc("syslib.getquerybandvaluesp", params)

print("name: {}, type: {}, value:{}".format(results.i_name, results.i_search_type, results.o_value))

params = (
    teradata.InOutParam(0, "i_search_type"),
    teradata.InOutParam('Name', "i_name"),
    teradata.OutParam("o_value")
)
results = session.callproc("syslib.getquerybandvaluesp", params)
print("name: {}, type: {}, value:{}".format(results.i_name, results.i_search_type, results.o_value))

results in this The first one correct the second one not so correct but the second one is the parameters in the order for the SP

name: Name, type: 0, value:TEST
name: Name, type: TEST, value:

this is my config

• Platform: Windows-8-6.2.9200
• Python Version: 3.4.3
• Python Compiler: MSC v.1600 64 bit (AMD64)
• Python Build: ('v3.4.3:9b73f1c3e601', 'Feb 24 2015 22:44:40')
• UdaExec Version: 15.10.0.14

[escheie]

The contract for the "syslib.getquerybandvaluesp" function is two IN parameters and single OUT parameter. You are passing two INOUT parameters and a single OUT parameter.

For whatever reason ODBC is allowing this, and populating the result in the first INOUT/OUT parameter it finds.

If you change your params tuple to this, it will work as expected:

params = (0, 'Name', teradata.OutParam("o_value"))