I have a stored procedure in Teradata which runs fine in jdbc reader and errors out in running from sql select or sql execute steps in DQC .
Statement : ( stored procedure returns result set with from_date and to_date passed)
CALL DB.procedure_name(‘2018-08-28 06:00:00’,‘2018-08-28 08:00:00’);
Error Message :
Task execution failed: [Teradata Database] [TeraJDBC 14.10.00.39] [Error 3932] [SQLState 25000] HL7_SQL_RS_DYNAMIC_BUILD:Only an ET or null statement is legal after a DDL Statement.
It also executes fine in edit statement under both steps sql select and sql execute . But it fails when run with values hardcoded or parameters passed as well .
please let me know if there is any issue with Ataccama executing stored procedure .