oracle odbc ¶ÁÈ¡ numberÎÊÌâ
ÎÒµÄoracleÊý¾Ý¿âÓиö×Ö¶ÎÀàÐÍFD_USER_IDÊÇ number£¨38£©£¬ÎÒÓÃodbc¶ÁÈ¡Ëû£¬
ÆäÖÐCRecordset rs£»
CDBVariant v;
rs.GetFieldValue(FD_USER_ID, v,SQL_C_SLONG);
ÔÚÎҵĻú×ÓÉÏ ¶Á³öÀ´µÄv.m_lVal ÊÇÕýÈ·µÄ
µ«ÊÇÔÚÁíÍâµÄ»ú×ÓÉ϶Á Ìáʾ˵numberic out of rang
¸ú×ÙÁËÏ·¢ÏÖÊÇrs.GetFieldValue(FD_USER_ID, v,SQL_C_SLONG);ÖеÄSQL_C_SLONGÎÊÌâ ÓÚÊÇÎÒ»»³ÉÁË
SQL_C_CHAR£¬¶Á³öÀ´¸úÊý¾Ý¿âµÄ²»Ò»Ñù¡£È»ºó»»³ÉSQL_C_DOUBLE Ò²ÊDz»Ò»Ñù¡£Ó¦¸ÃÔõÃ´ÅªÄØ£¬SQL_C_SLONGÔÚÎÒ»ú×ÓÉ϶¼ÊǺõİ¡ ΪʲôÔÚ±ðµÄ»ú×ÓÉϾÍÓÐÎÊÌâÁËÄØ£¬»¹ÓÐûÓÐʲô°ì·¨²»ÓÃSQL_C_SLONG ÕýÈ·¶Á³öÀ´ÄØ
ûÈ˻ذ¡
À´¸öÈË»Ø ÎÒ¸ø·Ö ²»ÏëÀË·Ñ
Äã²»»áÊÇodbc°æ±¾²»¶Ô°É?
ÄãÔÚSQL°æËµ:
ÕÒµ½ÎÊÌâÁË ÏÈÕû³É×Ö·û´®µÄ ³öÀ´ÔÚת¾Í¿ÉÒÔÁË
SQL_C_SLONG
javaÖÐÓиö getBigDecimal£¬¿ÉÒÔÈ¡38λÉõÖÁ¸ü¶àλµÄ¡£
¿´¿´ÄãµÄÓïÑÔÖÐÓÐûÓжÔÓ¦µÄ°¡£¿
Ïà¹ØÎÊ´ð£º
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y
Äã² ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......