Archives of the TeradataForum

Message Posted: Tue, 09 Oct 2012 @ 19:34:09 GMT

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

Think I can answer my own question ....

SQL Statements that Cannot Be Used Dynamically

The following SQL statements cannot be used dynamically when you write a stored procedure that does not return a results set:

Cursor statements, including the following:

CLOSE

FETCH

OPEN

So clearly,

     SET sL_RunCsr = 'OPEN sG_Csr USING sP_ConId;';
     EXECUTE IMMEDIATE sL_RunCsr;

won't work.

Regards

David Clough
Senior BI Database Designer
BI Competency Centre

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