CREATE PROCEDURE using ODBC

Connectivity
Enthusiast

CREATE PROCEDURE using ODBC

I connect to Teradata using ODBC and I would like to create very simple stored procedure. When I call SQLPrepare I receive error "[Teradata][ODBC Teradata Driver][Teradata Database] Syntax error: Invalid SQL Statement.", but when I call the same CREATE PROCEDURE... statement using SQLExecDirect then it works. It also works using SQL Assistant with .NET Provider. I tried using ODBC driver 12 and 13.

Is it normal that SQLPrepare doesn't work with CREATE PROCEDURE and SPL?
1 REPLY
Teradata Employee

Re: CREATE PROCEDURE using ODBC


Yes it is expected. You cannot use SQLPrepare() for CREATE/REPLACE PROCEDURE.