LONG Datatypes

Posted by die van niekerkuu's on 

Error:  "inconsistent datatypes: expected - got CLOB "



A SELECT returning CLOB values must not use the DISTINCT clause



And in Peoplesoft SQL use %TextIn:


 SELECT A.DESCR50 
 , 
%TextIn(A.DESCRLONG) 
 , 
%TextIn(A.DESCRLONG_NOTES) 
 FROM PSCSM.PS_UP_BK_STD6_2VW A 


OR
Error:  Bind value is too long

 Use %TextIn

Comments

Post a Comment