Toad World® Forums

Teradata - Replace Stored Procedure

I’m receiving an Invalid SQL Statement error when trying to execute a REPLACE PROCEDURE command on Teradata v13.

It’s known limitation for the current version. Create/Replaceprocedure requires a special execution and has not been implemented. There isthe CR 94527 to track the issue and it’s targeting to be implemented in version 3.5.

Is there a way to pass the command through to Teradata without Toad checking syntax etc?

No, unfortunately there is no way to create procedure rightnow. It’s not about checking syntax or passing a statement through withoutchecking syntax. TOAD must use a special Teradata specific method to executeCREATE/REPLACE PROCEDURE statement and it was not implemented.