Hi, im having probles to execute a store procedure teradata with parameters too, if you could solve this problems please share your results.
im working with "Execute Sql Task", what i want do do is something like
sqlstatement: CALL SP_PRUEBA(@PARAMETER1,@PARAMETER2);
if i execute something like
sqlstatement: CALL SP_PRUEBA('par1','par2'); it works fine
but when i try to put some parameters i get the next error:
failed with the following error: "[Teradata Database]  A SQL command cannot contain both host variables and parameter tokens.".
Apreciate any help.
I can't create stored procedure which will execute (call) other existing stored procedures.
Can somebody help me?