Re: dynamic sql substr length strange value (aix/hp differences?)

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:<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

How do you mean ?
When we ran the same application on HP and AIX, we got a certain value on one and another one on the other. Besides, cat.table_name on both machine should be the same.

Thanks. Received on Sun Aug 01 2004 - 13:01:48 CEST