Archives of the TeradataForum

Message Posted: Tue, 09 Oct 2007 @ 12:45:43 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Mon, 8 Oct 2007 17:51:07 -->

Hello,

I have one requirement to build CALL statement in dynamic SQL. As per my knowledge we cannot build SELECT and CALL in dynamic SQL like below

     CALL dbc.sysexecsql('CALL '||:v_MyDb||'.'||:v_procName||';');

I need to have statement like above. Depending upon input and some other conditions it needs to call different Procedures. Can anybody suggest any work around for this.

Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>