|
Archives of the TeradataForumMessage Posted: Thu, 15 Apr 2010 @ 09:13:16 GMT
Hi everyone, I want to call a stored procedure within another procedure with dynamic SQL and I wrote a simple SPL named SPL_CALLER. But it does not work. REPLACE PROCEDURE SPL_CALLER(SPL_NAME VARCHAR(30)) BEGIN CALL DBC.SysExecSQL('CALL ' || :SPL_NAME || '()'); END; In the reference document, it says: The following SQL statements cannot be specified as dynamic SQL in stored procedures: CALL, DATABASE, HELP, SELECT What kind of an approach should I follow? Regards, Selim Cubuk
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||