紧急求救，在线等？插入数据库的问题？

Question

请问各位高手，在vb中需要用什么方式才能插入一下的一段数据到oracle里？用insert语句报错为  ORA-01704: 文字字符串过长
语句于下：
insert into DBSession(SessionID,VarName,VarVal,SessionType,SessionUser) values(3197,'user_sequence',217,2067,1499,3298,3572,3201,1940,1388,2890,1422,1251,1470,1660,3165,1225,2044,3236,2478,2755,3657,1494,2770,2280,2580,3317,2060,1739,2827,1355,1846,3128,3364,2095,3534,3350,1774,1751,3327,2484,1759,1506,2353,1849,3595,3563,1250,1248,1905,1888,1827,2498,2940,3292,2322,1901,3348,2604,2041,1291,1589,2240,1981,1518,1442,3304,1270,2392,1182,1573,3332,2716,2214,2982,3607,2539,1645,3329,2349,3159,3631,3409,3220,1423,2105,2123,2326,2578,3193,2901,3674,1279,2337,2046,2341,2751,1496,3532,1249,1581,1639,2376,1823,2396,1193,1295,1267,3637,3279,1473,1579,1624,1692,1728,2426,2211,3612,3370,2265,2549,1548,2004,1505,1878,1479,2486,2908,2490,2522,3196,2659,1831,2084,1345,1451,2652,1531,2516,2000,1542,1577,3232,2836,1887,2064,2331,1811,1386,3436,2224,2673,1474,3005,1398,1266,3605,2531,2798,3115,3477,3098,3138,2283,2619,1997,3325,3570,1958,1204,3635,2524,1704,3592,2596,1893,1532,3464,2310,3307,2086,1441,3423,1732,3486,2371,2879,2968,3527,3311,3351,2469,3291,1212,1947,1324,2467,3051,2007,2725,1641,1432,2816,3625,2266,3183,
3456,2259,1971,2290,3546,1507,2381,2921,2688,2571,1962,3223,1520,1683,1837,2468,2895,1566,1580,2701,2789,3484,3400,1307,2232,1427,1862,1186,3554,3207,2882,1338,3461,2334,3658,3416,1381,1721,2057,3030,1408,3175,2972,2393,2732,1223,2302,1382,3330,3462,1612,2591,1554,2838,3593,2075,1872,2529,2309,1436,2002,1886,2201,1686,2556,1691,2518,2861,2188,2569,2643,2902,3290,2909,1224,2207,1876,1311,2593,2880,2033,2877,1180,2335,2475,2267,1184,1950,1933,1919,2839,2008,2476,1377,2546,1616,2107,2503,2459,3210,3408,3453,2975,1871,2458,1163,1918,2299,1812,2674,1413,1875,2598,1921,2563,2225,2311,1961,2496,2675,3255,3028,2137','manage_report',3)

Answer 1

建立一连接CONN，定义INSERT INTO TABLE，执行CONN.EXEC

Answer 2

你的字段为(SessionID,VarName,VarVal,SessionType,SessionUser) 
而你的值为(3197,'user_sequence',217,2067,1499,3298,3572,3201,1940,1388,2890,1422,1251,1470,1660,3165,1225,2044,3236,2478,2755,3657,1494,2770,2280,2580,3317,2060,1739,2827,1355,1846,3128,3364,2095,3534,3350,1774,1751,3327,2484,1759,1506,2353,1849,3595,3563,1250,1248,1905,1888,1827,2498,2940,3292,2322,1901,3348,2604,2041,1291,1589,2240,1981,1518,1442,3304,1270,2392,1182,1573,3332,2716,2214,2982,3607,2539,1645,3329,2349,3159,3631,3409,3220,1423,2105,2123,2326,2578,3193,2901,3674,1279,2337,2046,2341,2751,1496,3532,1249,1581,1639,2376,1823,2396,1193,1295,1267,3637,3279,1473,1579,1624,1692,1728,2426,2211,3612,3370,2265,2549,1548,2004,1505,1878,1479,2486,2908,2490,2522,3196,2659,1831,2084,1345,1451,2652,1531,2516,2000,1542,1577,3232,2836,1887,2064,2331,1811,1386,3436,2224,2673,1474,3005,1398,1266,3605,2531,2798,3115,3477,3098,3138,2283,2619,1997,3325,3570,1958,1204,3635,2524,1704,3592,2596,1893,1532,3464,2310,3307,2086,1441,3423,1732,3486,2371,2879,2968,3527,3311,3351,2469,3291,1212,1947,1324,2467,3051,2007,2725,1641,1432,2816,3625,2266,3183,
3456,2259,1971,2290,3546,1507,2381,2921,2688,2571,1962,3223,1520,1683,1837,2468,2895,1566,1580,2701,2789,3484,3400,1307,2232,1427,1862,1186,3554,3207,2882,1338,3461,2334,3658,3416,1381,1721,2057,3030,1408,3175,2972,2393,2732,1223,2302,1382,3330,3462,1612,2591,1554,2838,3593,2075,1872,2529,2309,1436,2002,1886,2201,1686,2556,1691,2518,2861,2188,2569,2643,2902,3290,2909,1224,2207,1876,1311,2593,2880,2033,2877,1180,2335,2475,2267,1184,1950,1933,1919,2839,2008,2476,1377,2546,1616,2107,2503,2459,3210,3408,3453,2975,1871,2458,1163,1918,2299,1812,2674,1413,1875,2598,1921,2563,2225,2311,1961,2496,2675,3255,3028,2137','manage_report',3)
是不是多得过了头。

Answer 3

字段和值相差太多了吧，是不是'user_sequence'后面的逗号接着的应该是字符串，少了一个单引号所以插不进吧你的语句应该是这样的insert into DBSession(SessionID,VarName,VarVal,SessionType,SessionUser) values(3197,'user_sequence','217,2067,1499,3298,3572,3201,1940,1388,2890,1422,1251,1470,1660,3165,1225,2044,3236,2478,2755,3657,1494,2770,2280,2580,3317,2060,1739,2827,1355,1846,3128,3364,2095,3534,3350,1774,1751,3327,2484,1759,1506,2353,1849,3595,3563,1250,1248,1905,1888,1827,2498,2940,3292,2322,1901,3348,2604,2041,1291,1589,2240,1981,1518,1442,3304,1270,2392,1182,1573,3332,2716,2214,2982,3607,2539,1645,3329,2349,3159,3631,3409,3220,1423,2105,2123,2326,2578,3193,2901,3674,1279,2337,2046,2341,2751,1496,3532,1249,1581,1639,2376,1823,2396,1193,1295,1267,3637,3279,1473,1579,1624,1692,1728,2426,2211,3612,3370,2265,2549,1548,2004,1505,1878,1479,2486,2908,2490,2522,3196,2659,1831,2084,1345,1451,2652,1531,2516,2000,1542,1577,3232,2836,1887,2064,2331,1811,1386,3436,2224,2673,1474,3005,1398,1266,3605,2531,2798,3115,3477,3098,3138,2283,2619,1997,3325,3570,1958,1204,3635,2524,1704,3592,2596,1893,1532,3464,2310,3307,2086,1441,3423,1732,3486,2371,2879,2968,3527,3311,3351,2469,3291,1212,1947,1324,2467,3051,2007,2725,1641,1432,2816,3625,2266,3183,
3456,2259,1971,2290,3546,1507,2381,2921,2688,2571,1962,3223,1520,1683,1837,2468,2895,1566,1580,2701,2789,3484,3400,1307,2232,1427,1862,1186,3554,3207,2882,1338,3461,2334,3658,3416,1381,1721,2057,3030,1408,3175,2972,2393,2732,1223,2302,1382,3330,3462,1612,2591,1554,2838,3593,2075,1872,2529,2309,1436,2002,1886,2201,1686,2556,1691,2518,2861,2188,2569,2643,2902,3290,2909,1224,2207,1876,1311,2593,2880,2033,2877,1180,2335,2475,2267,1184,1950,1933,1919,2839,2008,2476,1377,2546,1616,2107,2503,2459,3210,3408,3453,2975,1871,2458,1163,1918,2299,1812,2674,1413,1875,2598,1921,2563,2225,2311,1961,2496,2675,3255,3028,2137','manage_report',3)