A puzzle of using OPD - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>DotNet - 窗口里的风景

A puzzle of using OPD

A puzzle of using OPD# DotNet - 窗口里的风景

c*t2008-09-24 07:09

1 楼

Using Oracle Data Provider for .Net, call a stored procedure with OUT cursor
, which equivalent to:
select max(integer_field) as blah,....
After fill the dataset, I check the datatables[0]: the data type of blah
CHANGED to decimal!!
I made it work by altering sp, cast the max to integer... any better
approach? and why ODP change the data type?

c*e2008-09-24 07:09

2 楼

http://download.oracle.com/docs/html/B28089_01/featTypes.htm

cursor

【在 c**t 的大作中提到】

: Using Oracle Data Provider for .Net, call a stored procedure with OUT cursor
: , which equivalent to:
: select max(integer_field) as blah,....
: After fill the dataset, I check the datatables[0]: the data type of blah
: CHANGED to decimal!!
: I made it work by altering sp, cast the max to integer... any better
: approach? and why ODP change the data type?