Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 28 Mar 2016 @ 19:44:33 GMT


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


Subj:   Store procedure not compiling
 
From:   Bakthavachalam, Roopalini

Hi Forum,

We have two Teradata servers (Dev and prod) of exact same version (version - 15.00.03.03 , Release - 15.00.03.04). I am trying to compile a store procedure on production server which was recently upgraded and it is failing with the below error.

Missing/Invalid SQL statement'E(9267):A nondeterministic SQL expression passed as an argument to an SQL UDF cannot correspond to a parameter that appears more than once in the return statement.

However the same procedure runs perfectly on the development server.

I had posted a question on the above error I got few days back and the response I received was to use CHAR_LENGTH instead of LENGTH. However now after the upgrade I am expecting the procedure to compile without any issues on the prod server.

Could this be due to the default database (SYSLIB/TD_SYSFNLIB) that is used to pull the functions different in prod and dev server?

Could someone please clarify? Appreciate the response.

Thanks

Roopalini



     
  <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