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 "
=> 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