Survey banner
The Dataiku Community is moving to a new home! New posts are now disabled and the community will shortly be in temporary read only mode: LEARN MORE

Capturing OUT parameters of stored procedures

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] [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)
A banner prompting to get Dataiku