From: kennedy-downwithspammersfamily@attbi.net   
      
   "Ari"  wrote in message   
   news:b4724890.0407290755.13031588@posting.google.com...   
   > we have a strange problem with oracle dynamic sql method 4.   
   > when selecting a substr we expect to, and normally, receive from   
   > oracle in the describe select list (SELDSC) the length of the   
   > substring. For example, when performing "select substr(table_name,1,5)   
   > from cat" we expect to receive the length of 5. This indeed happens on   
   > our aix machine, but on a customer's hp machine we receive the length   
   > 30 (the length of table_name.) We have also noticed that within   
   > sqlplus, if we perform "substr(table_name,1,5) from cat" the title on   
   > the aix machine is "SUBST" while on the hp machine it is   
   > "substr(table_name,1,5)" padded to 30 characters. Does anyone have an   
   > explanation for this bizarre behavior?   
   One is a varchar and the other is a char column.   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)