Archives of the TeradataForum
Message Posted: Tue, 09 Oct 2007 @ 12:45:43 GMT
<-- Anonymously Posted: Mon, 8 Oct 2007 17:51:07 -->
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|