OCI-22053: overflow error caused when retreiving valid data inserted using System.Data.OracleClient

最新推荐文章于 2024-11-08 11:29:06 发布

photnman

最新推荐文章于 2024-11-08 11:29:06 发布

阅读量2k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle 文章标签： string microsoft translation oracle insert application

本文链接：https://blog.youkuaiyun.com/photnman/article/details/435214

Oracle 专栏收录该内容

33 篇文章

订阅专栏

博客介绍了使用System.Data.OracleClient插入有效数值（Decimal）后无法用相同客户端检索的示例，指出这可能是Oracle客户端与Microsoft数据提供程序间的按位翻译错误，测试环境为VisualStudio2003、Oracle 9i客户端及服务器，均运行在Windows 2000 SP4上。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

See the following example of how to insert a valid numeric value (a Decimal) using the System.Data.OracleClient that cannot be retreived using the same System.Data.OracleClient.

It is apparently some sort of bit-wise translation error between the Oracle Client and the Microsoft Data Provider. This test was run with VisualStudio2003 and Oracle 9i Client v9.2.0.4.0 connecting to Oracle Server 9.2.0.4.0, all running on Windows 2000 SP4.

using System;
using System.Data;
using System.Data.OracleClient;

namespace OdpTest
{
    /// <summary>
    /// The following command line application code illustrates haw a value that was inserted
    /// using the System.Data.OracleClient causes an overflow error when retreiving it using
    /// the same System.Data.OracleClient.
    /// </summary>
    public class OverflowTest
    {
        private const string CONNECT_STRING = "USER ID=foo;PASSWORD=bar;DATA SOURCE=foobar";

        [STAThread]
        private static void Main(string[] args)
        {
            using (OracleConnection conn = new OracleConnection(CONNECT_STRING))
            {
                conn.Open();
                try
                {
                    using (OracleCommand createCmd = conn.CreateCommand())
                    {
                        createCmd.CommandText = "create table overflow_test (num NUMBER)";
                        createCmd.ExecuteNonQuery();
                    }

                    using (OracleCommand insertCmd = conn.CreateCommand())
                    {
                        insertCmd.CommandText = "insert into overflow_test (num) values (:a)";
                        OracleParameter p = insertCmd.CreateParameter();
                        p.ParameterName = "a";
                        p.Value = 61M / 3M; // The magic value (there are more than just this one)
                        p.Direction = ParameterDirection.Input;
                        p.DbType = DbType.Decimal;
                        insertCmd.Parameters.Add(p);
                        Console.Error.WriteLine("Storing value: " + p.Value.ToString());
                        insertCmd.ExecuteNonQuery();
                    }

                    using (OracleCommand selectCmd = conn.CreateCommand())
                    {
                        selectCmd.CommandText = "select * from overflow_test";

                        DataTable overflowTest = new DataTable("overflow_test");
                        DataColumn num = new DataColumn("num", typeof (decimal));
                        overflowTest.Columns.Add(num);

                        OracleDataAdapter oda = new OracleDataAdapter(selectCmd);
                        oda.Fill(overflowTest);

                        int i = 0;
                        foreach (DataRow row in overflowTest.Rows)
                        {
                            Console.Error.Write("Row[{0}]:", i);
                            for (int j = 0; j < row.Table.Columns.Count; j++)
                            {
                                Console.Error.Write(" {0}", row[j]);
                            }
                            Console.Error.WriteLine();
                        }
                        i++;
                    }
                }
                finally
                {
                    using (OracleCommand deleteCmd = conn.CreateCommand())
                    {
                        deleteCmd.CommandText = "drop table overflow_test";
                        deleteCmd.ExecuteNonQuery();
                    }
                }
            }
        }
    }
}