Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle & SQLS7 data type question!

Status
Not open for further replies.
Marcha

Marcha

Programmer
Nov 1, 2000
7
LV
Have anyone run into this? I have Oracle and sql server set up as linked servers (from SQLS), then I try select statement on some table, the result is weird: char and varchar columns are displayed properly but number (numeric) all are displayed as zeros (if i insert the number from SQL and then retrieve it, it works), also when inserting numbers into Oracle, I found that I cannot insert numbers with precision.
Any suggestions and help appreciated.
Thanks!
Marcha
 
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
976
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
SSMS question 1
Replies
4
Views
1K
Sana Shazadi
S
Andrzejek
  • Locked
  • Question
Field types question
Replies
9
Views
699
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Data types and sizes
Replies
18
Views
1K
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top