Programming/.NET

서버에서 요청을 처리할 수 없습니다(ORA-01008: not all variables bound)

초록깨비 2008. 12. 4. 09:09
728x90
System.Web.Services.Protocols.SoapException: 서버에서 요청을 처리할 수 없습니다. ---> CoreLab.Oracle.OracleException: ORA-01008: not all variables bound
   => biz로직에 컬럼 정의 안하면 발생하는 오류
      Private _SourceColumns As String = "BRAND, " & _
                                         "SEASON_YEAR,  " & _
                                         "SEASON,    " & _
                                         "BRAND_NAME,   " & _
                                         "SEASON_NAME,   " & _
                                         "STOCK_QTY_ALL,   " & _
                                         "STOCK_QTY_ALL_B,  " & _
                                         "STOCK_QTY_ALL_H,  " & _
                                         "STOCK_QTY_A,      " & _
                                         "STOCK_QTY_A_B,    " & _
                                         "STOCK_QTY_A_H,   " & _
                                         "STOCK_QTY_PART,  " & _
                                         "STOCK_QTY_PART_B, " & _
                                         "STOCK_QTY_DPART_B," & _
                                         "STOCK_QTY_GPART_B," & _
                                         "STOCK_QTY_KPART_B," & _
                                         "STOCK_QTY_MPART_B," & _
                                         "STOCK_QTY_TPART_B," & _
                                         "STOCK_QTY_PART_H, " & _
                                         "STOCK_QTY_DPART_H," & _
                                         "STOCK_QTY_GPART_H," & _
                                         "STOCK_QTY_KPART_H," & _
                                         "STOCK_QTY_MPART_H," & _
                                         "STOCK_QTY_TPART_H "
728x90