Home » Infrastructure » Other Operating Systems » Re: DB upgrade from 8.0.6 to 9.2.0.10 under MVS os/390
Re: DB upgrade from 8.0.6 to 9.2.0.10 under MVS os/390 [message #63645] Sat, 23 October 2004 07:35
Raymond
Messages: 30
Registered: September 2000
Member
 Previously our system is running in Oracle 8.0.6 under MVS system.

 after our migration on our test machine to 9.2.0.10 and Oracle report6i with patch 13.

  OUr report which mainly printing the address is running out of order

  What we do at our address columns is we concat
   add1 ||chr(13)|| add2 ||chr(13)||add3

 Previously on report 4.5 and Oracle 8.0.6 the address is printout correctly.

      No 13,Penang Street
      Roberson Garden
      50190 SG.

Now is
      NO 13, Penang Street
         ROberson Garden
             50190 SG.

I try to test select chr(13) from dual and it give me '|' but when i insert this chr(13) into a varchar2 columns it store as '||' ??

Any comment?
Previous Topic: Where i can find the oracle client for MAC OS9 ?
Next Topic: Sending a pop-up message to an internet IP address
Goto Forum:
  


Current Time: Sun Dec 21 14:33:04 CST 2014

Total time taken to generate the page: 0.08761 seconds