错误：Oracle.DataAccess.Client.OracleException：ORA-01722：无效的数字。任何1可以帮助我解决此错误。 [英] Error : Oracle.DataAccess.Client.OracleException: ORA-01722: invalid number. Can any 1 help me to resolve this error.

问题描述

以下是查询





（SELECT TO_CHAR（NVL（MAX（ID），0））FROM BRANCH WHERE UPPER （BRANCHNAME）= UPPER（：VAL）AND COMPANY_ID =：Company_ID）;

Following is the query


(" SELECT TO_CHAR(NVL(MAX(ID),0)) FROM BRANCH WHERE UPPER(BRANCHNAME) = UPPER(:VAL) AND COMPANY_ID=:Company_ID ");

o_Cls_OracleConnect.OracleCommand_PreInit(sb.ToString());
         o_Cls_OracleConnect.Parameter_Int32("Company_ID", Company_ID);
         o_Cls_OracleConnect.Parameter_String("VAL", val);

         returnCount = Convert.ToInt32(o_Cls_OracleConnect.ExecuteScalar());
         return returnCount;
     }

public string ExecuteScalar()
    {
        try
        {
            obj_temp = MyCmd.ExecuteScalar();
            if (obj_temp == null)
            {
                s_temp = "";
            }
            else
            {
                s_temp = obj_temp.ToString();
            }
            return (s_temp);
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            if (!(MyCmd == null))
            {
                MyCmd.Dispose();
            }
            MyCmd = null;
        }
    }

上述函数发生错误时捕获异常： 无效号码。任何1都可以帮我解决这个错误。

The error occurs for above function it catches exception : Invalid number. Can any 1 help me to resolve this error.

推荐答案

嘿，



您正在使用to_char in您的选择列表，并尝试将其转换为代码中的int32。这不起作用....



问候，佩里

Hey,

You are using to_char in your select list and you try to convert it to an int32 in code. This will not work....

Regards, Perry

这篇关于错误：Oracle.DataAccess.Client.OracleException：ORA-01722：无效的数字。任何1可以帮助我解决此错误。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！