Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Re: Need help with Stored Procedure: SELECT INTO clause
 
From:   David Clough

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020