RE: Oracle Computed column datatype

Hi SP,

Thanks for your detailed explanation. Yes, I have reproduced that on my
machine with linked server.

Based on my research, this is a known issue. Would you please try to
specify both precision and scale for the number column instead of only one
value. This might be the only solution on this issue, because Oracle
handles Numeric columns differently from other databases. You can check the
following two KB articles for more information on this.

http://support.microsoft.com/?kbid=243027
http://support.microsoft.com/?kbid=221552

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

.

Relevant Pages

  • Re: Counting individual dates
    ... This will give you a detailed explanation of the function and it's uses: ... HTH, ... Please keep all correspondence within the Group, ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: shortcut to a function?
    ... detailed explanation. ... Odd formula you showed, the>0 doesn't seem to do anything. ... HTH ... Bob Phillips ...
    (microsoft.public.excel.misc)
  • Re: problems with FP 2003 dhtml
    ... Hi Kevin, I did reply with a detailed explanation. ... > solve puzzles for a living ...
    (microsoft.public.frontpage.client)
  • Re: linked server
    ... HTH, Jens SUessmeyer. ... > anyone knows how to verify if a linked server is active only using SQL ...
    (microsoft.public.sqlserver.connect)
  • Linked Server-New tables missing
    ... disconnect and reconnect ... >I have a linked server to Sybase ASE 12.5 that has been ...
    (microsoft.public.sqlserver.server)