Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 May 2004 @ 08:43:00 GMT


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


Subj:   Displaying a stored procedures out parameter..
 
From:   Sonny Chee

Hi Guys,

Anyone know how to display the out parameter after a call to a stored procedure? It would be ideal if I could do something like the following in QueryMan or BTEQ.

     declare outVariable;

     call myProc(outVariable);

     print outVariable;

This is of course just pseudocode as I know declare only works in a stored proc and there is no print statement (although strangely enough the compiler doesn't complain about the print keyword in a stored procedure...).


Sonny.



     
  <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: 27 Dec 2016