Re: dynamic sql substr length strange value (aix/hp differences?)
Date: Fri, 30 Jul 2004 03:00:44 GMT
Message-ID: <wRiOc.180999$%_6.171660_at_attbi_s01>
"Ari" <unikoski_at_yahoo.com> wrote in message
news: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?
One is a varchar and the other is a char column.
Jim
Received on Fri Jul 30 2004 - 05:00:44 CEST