Community Conundrum 25:Feature Visualization is now live! Read More

Capturing OUT parameters of stored procedures

Dataiker
Dataiker
Capturing OUT parameters of stored procedures
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?
1 Reply
Level 2

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.



 

0 Kudos
Labels (5)