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?

"Ari" <unikoski (AT) yahoo (DOT) com> wrote

Jim

"Jim Kennedy" <kennedy-downwithspammersfamily (AT) attbi (DOT) net> wrote

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.