Please, help with this procedure.
replace procedure test_proc(inp varchar(10))beginDECLARE VV varchar(64000);set VV='replace procedure test_proc23()SPBEGIN:BEGINDECLARE out1 varchar(500);DECLARE out2 integer;call TD_SYSXML.XMLPUBLISH('' sel * from Name'', null,:out1,:out2);insert into svt24'||inp||' values (:out1,:out2);END SPBEGIN;';EXECUTE IMMEDIATE VV;end;
ERROR: TEST_PROC:Syntax error: Invalid SQL Statement.
Does is possible to create a procedure to dynamically in Teradata? Or how to correct this code?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.