Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 13:17:19 GMT


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


Subj:   Re: Capturing Error Messages - Stored Procedures
 
From:   Padmini_Bhattiprolu

Hi,

I do not think, the current implementation will capture the error message in stored procedure. We can always check the error message corresponds to the SQLCODE in the DBC.ERRORMEGS table. If any of the handlers does not exist CALL will report that error. In case if the handler exists, you can capture the SQLSTATE and SQLCODE and check for the error message.


-- Padmini



     
  <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: 15 Jun 2023