dynamic sql substr length strange value (aix/hp differences?)
From: Ari <unikoski_at_yahoo.com>
Date: 29 Jul 2004 08:55:50 -0700
Message-ID: <b4724890.0407290755.13031588_at_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? Received on Thu Jul 29 2004 - 17:55:50 CEST
Date: 29 Jul 2004 08:55:50 -0700
Message-ID: <b4724890.0407290755.13031588_at_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? Received on Thu Jul 29 2004 - 17:55:50 CEST