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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Ari
    #1

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

    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_na me,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_n ame,1,5) from cat" the title on
    the aix machine is "SUBST" while on the hp machine it is
    "substr(table_n ame,1,5)" padded to 30 characters. Does anyone have an
    explanation for this bizarre behavior?
    Tags: None
    • Jim Kennedy
      #2
      Re: dynamic sql substr length strange value (aix/hp differences?)


      "Ari" <unikoski@yahoo .comwrote in message
      news:b4724890.0 407290755.13031 588@posting.goo gle.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_na me,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_n ame,1,5) from cat" the title on
      the aix machine is "SUBST" while on the hp machine it is
      "substr(table_n ame,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


        Comment

        • Marat
          #3
          Re: dynamic sql substr length strange value (aix/hp differences?)

          "Jim Kennedy" <kennedy-downwithspammer sfamily@attbi.n etwrote in message news:<wRiOc.180 999$%_6.171660@ attbi_s01>...
          "Ari" <unikoski@yahoo .comwrote in message
          news:b4724890.0 407290755.13031 588@posting.goo gle.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_na me,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_n ame,1,5) from cat" the title on
          the aix machine is "SUBST" while on the hp machine it is
          "substr(table_n ame,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.

            Comment

            Previous template Next
            Working...