Error in Executing Stored Procedure


(sivaraman gangadharan) #1

Hello ,
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 .


(sivaraman gangadharan) #2

any updates on this topic .


(Katrin Popova) #3

Hello Siva,

Could you please try with enabled autocommit mode?

• SQL Execute change the Commit size to 1:
image
• SQL Select step
image

Regards,
Katrin


(sivaraman gangadharan) #4

Hi Katrin ,
Since the stored proc returns result set , i can only use sql select step .
I enabled Autocommit in sql select step , but still throws the same error .


(Katrin Popova) #5

Hello Siva,

I need more time to perform tests, I will write you soon.

Regards,
Katrin


(Katrin Popova) #6

Hello Siva,

I tested and was not able to reproduce the error. if possible could you please send me your procedure and sample data? So I could recreate the same conditions?

Thank you,
Regards,
Katrin