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 - 10:55:50 CDT
