InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 15:40:58 GMT20http://www.teradata.com/teradataforum/Topic10910-5-1.aspxA procedure can call other procedures. So you can have a macro call a procedure and that procedure can call other procedures. Keep in mind that everything executed by a macro is one request. Why not just call the procedure directly? Why have it go through a macro first?Mon, 17 Mar 2008 22:52:57 GMTrgshttp://www.teradata.com/teradataforum/Topic10910-5-1.aspxwhen I try to execute code like the example I posted, I get Error 5497: CALL can not be submitted in multi statement request.If I eliminate all but one CALL stmt, it works, as suggested by the Error msg, but that doesn't help me at all. Any suggestions?Fri, 14 Mar 2008 09:01:53 GMTm_nardonehttp://www.teradata.com/teradataforum/Topic10910-5-1.aspxmacros can call stored procedures as well as execute other macros ...however you cannot execute a macro from a stored proc as of v2r6Fri, 14 Mar 2008 00:11:28 GMTjoedsilvahttp://www.teradata.com/teradataforum/Topic10910-5-1.aspxOn a similar note, I have two questions:a. can stored procs be called from a macro? -- see belowI want to use the macro like to pass the parm to the stored procsb. can macros execute other macros?again using it as a "driver" to ensure that the correct macros are executed.example of a.REPLACE MACRO my_db.my_macro (table_parm VARCHAR(30) ) AS(CALL SP_1(':table_parm') ;CALL SP_2(':table_parm') ;CALL SP_3(':table_parm') ;CALL SP_4(':table_parm') ;CALL SP_5(':table_parm') ;);then execute using EXEC my_macro ('customer') ;Thu, 13 Mar 2008 13:44:09 GMTm_nardonehttp://www.teradata.com/teradataforum/Topic10910-5-1.aspxNo, but you can call a UDFThu, 13 Mar 2008 01:01:14 GMTjoedsilvahttp://www.teradata.com/teradataforum/Topic10910-5-1.aspxHi,In Teradata , Can we call a stored procedure thru a view ( this is possible in oracle ) ?And pointers would be highly appreciated.Regards,MadhaviWed, 12 Mar 2008 14:58:44 GMTMadhavik