FIX: Oracle ??? ???????? ????? ???? 7354 ??????

???? ?????? ???? ??????
???? ID: 243027 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
BUG #: 36489 (SQLBUG_70)
BUG #: 18722 (SQLBUG_70)
BUG #: 47131 (SQLBUG_70)
??? ?? ??????? ???? | ??? ?? ??????? ????

?????

??? Oracle ???? ??? ?? ????? ?? ????? Microsoft OLE DB ??????? ?? ??? Oracle (MSDAORA) ?? ???? ?????? ?? ??? ??????? ?? ????? ???? ?? ?????? ?? ??? ??????????????? ?? ????? ?? ???? ?? ?????? ?? ???? ?? ???? ??:
?????: ????? 7354, ???? 16, ?????-1, ?????? 1 OLE DB ??????? 'MSDAORA' ???? 'columnname' ????? ?? ??? ?????? ????????? ???? ?????? ??????? ???? ???
??? ?????? ???? ?? ?? ???? ??numericcolumn is not in the select list.

????

The column with thenumericdata type has no length specified (no precision, no default, allows NULL). Thenumericdata type without a precision and scale is represented in Oracle by a variable-lengthnumericwith precision of up to 255.

????? ?????????

For more information about possible workarounds, see the following article in the Microsoft Knowledge Base:
221552PRB: SQL Distributed Query with Oracle NUMERIC Column Gives Error

??????

Microsoft ?? ?????? ?? ?? SQL Server 7.0 ??? ??? ?????? ??? ????? ?????? ?? ?? ??? ???? ??. ??. ?????? ??? 2 ??? Microsoft SQL Server 7.0 ?? ???????? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
254561INF: Microsoft SQL Server 7.0 ?? Microsoft ???? ????? (MSDE) 1.0 ?? ??? ?????? ??? 2 ?? ??????? ???? ?? ??? ????
???? ??????? ?? ???, ???? ?????? ?? ???????? ??????? ?? ?????? ?????

???? ???????

??? ?? SQL Server 7.0 ?????? ??? 2 (SP2) ??? ?????? ?????? ?? ??? ???? ?? ????? ?? ???, SP2 ?? ????? ???? ??????? ?? ??????? ???????sp_columns_ex?????? ???????? ????????? ??? ????? ?? ??? ???? ?? ???sp_columns_ex????? ?????? ???? ??? ?? ?? ???? ??:
?????: ????? 515, ???? 16, 2 ?????? ???, ????????? sp_columns_ex, ?????? 133
???????? ???? ?? ???? ????? 'DATA_TYPE', ??? ?? ??? ?????? 'tempdb.dbo.#tmp_columns_XX'; ????? nulls ?? ?????? ???? ????? ???????? ???? ???? ???? ??? ??? ?? ??? ?? ???? ??? ???
?? ?????? ?? ??? ???? ?? ??? SP2 ?? INSTCAT.SQL ????????? ?????? ?? ????????? ????? ?? ??? ???? ?? ????????? ?? ??? SQL Server 7.0 ???????? ?????? ??? "???? ???? ?? ??? ???????? ?????? ???????? ????????????" ???? ??????

??? Oracle?????????????? ?? ??? ?? ??? ??nvarchar(384) ??????? ?? ??? ???? ??? ?? ??? ???????????SQL ????? ?? ???????

???

???? ID: 243027 - ????? ???????: 02 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 7.0 Standard Edition
??????: 
kbbug kbfix kbmt KB243027 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:243027

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com