Capturing OUT parameters of stored procedures
![UserBird](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar12.png)
UserBird
Dataiker, Alpha Tester Posts: 535 Dataiker
Hi, I am trying to call a stored procedure using a Teradata connection in Dataiku. This is done through SQLExecutor in a python recipe. However, the result of query_to_df is just an empty dataframe. Normal SELECT queries run fine; they return results. Just stored procedures return empty. I query it using 'CALL PROCEDURE_NAME(OUT param);' Is there a setting I need to change in Dataiku to be able to capture the OUT parameters of the procedure?
Tagged:
Answers
-
Strangely I am getting the following error message when I execute a Teradata Stored Procedure
CALL FLRegrDataPrep('FL_REV4628.tblAdultDataWide','ObsID','income','tblAdultData_Deep','ObsID','VarID','Num_Val',2,0,0,0,0,0,0,NULL,NULL,NULL,NULL,?)[Teradata Database] [TeraJDBC 15.10.00.35] [Error 7504] [SQLState HY000] in UDF/XSP/UDM FL_REV4628.FLRegrDataPrep: SQLSTATE 00393: Only an ET or null statement is legal after a DDL Statement.