Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 10 Jun 2002 @ 21:15:58 GMT


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


Subj:   Stored procedure calls with OUT paramters, how?
 
From:   Charles McDevitt

I have a situation where I want to call a stored procedure. This stored procedure is known to have three out parameters, But the application doesn't know the name of these parameters.

In other database systems, using normal dynamic SQL, I would call The procedure with SQL like "call myproc(?,?,?);".

But apparently Teradata doesn't like this. If I knew the name of the parameters, I could call it like "call myproc(paramx,paramy,paramz);", and that would work.

But is there any way to call a stored procedure that has OUT parameters without knowing the OUT parameter names?


Thanks!

Charles F McDevitt

www.mcdevitt.san-francisco.ca.us



     
  <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