³öÏÖOracle ORA 24343µÄÒ»ÖÖÇé¿ö
¶ÔÓÚOracle ORA-24343ÕâÖÖ´íÎó£¬OracleµÄ¹Ù·½½âÊÍÊÇ£º
Error Message: ORA-24343 user defined callback error
Error Cause:
The only valid return value for a user defined callback function is OCI_ CONTINUE. Any other value will cause this error.
Action:
Make sure that OCI_CONTINUE is returned from the user-defined callback function.
×î½üÓÃPro*C±àд·ÃÎÊOracleµÄÊý¾Ý¿âµÄ³ÌÐò£¬Óöµ½ÁËÕâ¸ö´íÎó£¬×îºó·¢ÏÖµ¼ÖÂÕâ¸ö´íÎóµÄÒ»¸öÔÒòÊÇ
“ËÞÖ÷±äÁ¿”µÄ³¤¶È·ÖÅä²»¹»¡£
È磺
EXEC SQL BEGIN DECLARE SECTION;
char completion_time[30];
char completion_time2[30];
char SQLSTR[500];
EXEC SQL END DECLARE SECTION;
string SQL = "select to_char(SWITCH.scan_start_time,'YYYY-MM-DD HH24:MI:SS'), (SWITCH.innho_att - SWITCH.innho_fail) / SWITCH.innho_att, (SWITCH.extin_att + SWITCH.extou_att - SWITCH.extin_fail - SWITCH.extou_fail) / (SWITCH.extin_att + SWITCH.extou_att) from u_msc_h_ho@pmdb SWITCH where SWITCH.mscname = :equipe_name and (SWITCH.scan_start_time between to_date(:completion_time, 'YYYY-MM-DD HH24:MI:SS') and to_date(:completion_time, 'YYYY-MM-DD HH24:MI:SS') + 13) and SWITCH.innho_att is not null and SWITCH.innho_fail is not null and SWITCH.extin_att is not null and SWITCH.extin_fail is not null and SWITCH.extou_att is not null and SWITCH.extou_fail is not null and SWITCH.extin_att + SWITCH.extou_att != 0 and SWITCH.innho_att != 0 and to_char(SWITCH.scan_start_time, 'HH24') in ('08','09','10','11','18','19','20','21') ";
strcpy(SQLSTR, SQL.c_str());
EXEC SQL PREPARE SQLCursor from :SQLSTR;
EXEC SQL DECLARE GetSwitchSceneDataCursor CURSOR for SQLCursor;
EXEC SQL OPEN GetSwitchSceneDataCursor using :equipe_name, :com
Ïà¹ØÎĵµ£º
ÕâÀïÊ×ÏÈ˵ÏÂoracle·ÖÒ³²»Ïñmysql·ÖÒ³ÄÇô¼òµ¥Ö±½Ólimit ¾Í¿ÉÒÔÁË.
mysql£ºsql ="select * from talbe limit 0,10";
µÚÒ»¸öÊý±íʾϱ꣬¾ÍÊÇ´ÓµÚ¼¸ÌõÊý¾Ý¿ªÊ¼£¬
µÚ¶þ¸öÊý±íʾÿҳÏÔʾ¶àÉÙÌõÊý¾Ý£¬¿ÉÒÔ˵Êǵ±ÄãÈ·¶¨Ã¿Ò³ÏÔʾ¶àÉÙÐÐʱºò£¬Ëü¾ÍÊÇÒ»¸ö¹Ì¶¨µÄÊý¡£
ÕâÀïÐèҪעÒâµÄÊÇ£¬mysqlµÄ·ÃÎÊϱêÊÇ´Ó0¿ªÊ¼µÄ¡£Õ ......
Êý¾ÝÎļþ
¡¡¡¡Ã¿Ò»¸öOracleÊý¾Ý¿â¶¼ÓÐÒ»¸ö»ò¶à¸öÎïÀíµÄÊý¾ÝÎļþ,Êý¾Ý¿âÐÅÏ¢(½á¹¹,Êý¾Ý)¶¼±£´æÔÚÕâЩÊý¾ÝÎļþÖÐ,²¢ÇÒÕâЩÎļþÒ²Ö»Oracle²ÅÄܹ»½âÊÍÓë¹ÜÀíÕâЩ´æ´¢.OracleÊý¾ÝÎļþ¾ßÓÐÒÔÏÂÒ»Ð©ÌØÐÔ:
¡¡¡¡1.Ò»¸öÊý¾ÝÎļþ½ö½ö¹ØÁªÒ»¸öÊý¾Ý¿â,Êý¾ÝÎļþÓëÊý¾Ý¿âÖ®¼ä¶ÔÓ¦¹ØÏµÊÇÒ»¶ÔÒ»¹ØÏµ,µ±È»·´¹ýÊý¾Ý¿âÓëÊý¾ÝÎļþÊÇÒ»¶Ô¶à¹ØÏµ. ......
½ñÌì¼ÌÐøÊÔÑéÊ®·ÖÖÓ¿ÉÒÔ¸Éʲô£¬Ñ¡È¡Á˶ÔOracleË÷ÒýµÄ½éÉÜ£¬½á¹ûÈçÏ£º
´ÓgoogleÉÏѰÕÒ×ÊÁÏ£º1:15Ãë¡£
ÔĶÁ¸ÅÊö²¿·Ö£º3:15Ãë¡£
OracleµÄË÷ÒýÖ÷Òª°üº¬Á½ÀࣺBTreeºÍλͼË÷Òý¡£Ä¬ÈÏÇé¿öÏ´ó¶àʹÓÃBtreeË÷Òý£¬¸ÃË÷Òý¾ÍÊÇͨ³£Ëù¼û ΨһË÷Òý¡¢¾Û´ØË÷ÒýµÈµÈ£¬BtreeÓÃÔÚOLTP£¬¼Ó¿ì²éѯËÙ¶È¡£Î»Í¼Ë÷ÒýÊÇOracleµÄ±È½ÏÒýÈËעĿµÄµØ ......
ÔÚÏµÍ³Ç¨ÒÆ»òÉý¼¶µÄʱºò£¬¿ÉÄÜ»áÓÐoracle JOBÇ¨ÒÆµÄÐèÇó¡£
¶ÔÓÚ10GµÄϵͳºÃ˵¡£¿ÉÒÔÓÃÏÂÃæµÄ°ì·¨£º
userid="/ as sysdba"
directory=EXP_DIR
dumpfile=expdp_job.dmp
logfile=expdp_job.log
include=job
¶ÔÓÚ9i¿âºÃÏóÓе㸴ÔÓ£º
¿ÉÒÔÓÃÏÂÃæµÄ°ì·¨¡£
set echo on
conn sm ---------->JOBËùÔÚµÄÓû§Ãû¡£
set se ......
»ØÊÕÕ¾,´ÓÔÀíÉÏÀ´Ëµ¾ÍÊÇÒ»¸öÊý¾Ý×Öµä±í,·ÅÖÃÓû§DropµôµÄÊý¾Ý¿â¶ÔÏóÐÅÏ¢.Óû§½øÐÐDrop²Ù×÷µÄ¶ÔÏó²¢Ã»Óб»Êý¾Ý¿âɾ³ý,ÈÔÈ»»áÕ¼Óÿռä.³ý·ÇÊÇÓÉÓÚÓû§ÊÖ¹¤½øÐÐPurge»òÕßÒòΪ´æ´¢¿Õ¼ä²»¹»¶ø±»Êý¾Ý¿âÇåµô.Êý¾Ý¿âÓÐÁËÕâÑùµÄ¹¦ÄÜ,Äܹ»¼õÉٺܶ಻±ØÒªµÄÂé·³.¾³£¿´µ½¿ª·¢ÈËÔ±Îó°Ñ±íɾ³ý,¼±¼±Ã¦Ã¦ÕÒDBAÀ´Ïë°ì·¨µÄÇé¿ö,ÏàÐÅ,Ëæ×Å10G ......