How to call a stored procedure from PyODBC on a Teradata database?

Question

I am running

cursor.execute("""{call myStoredProcedure('abc')}""")

I get the following error:

Error: ('HY000', "[HY000] [Teradata][ODBC Teradata Driver][Teradata Database] 'myStoredProcedure' is not a macro.  (-3855) (SQLExecDirectW)")

Why is Teradata thinking that myStoredProcedure is macro and not a stored procedure?

I am able to run the usual select commands on the database. I can also run the stored procedure from the Teradata SQL Assisstant.

score 3 · Accepted Answer · answered Jul 24 '14 at 20:06

3

Try it without the curly braces:

cursor.execute("""call myStoredProcedure('abc')""")

And/or check the setting for the DisableCALLToEXECConversion option

answered Jul 24 '14 at 20:06

dnoeth

1 Answers1