³öÏÖ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
Ïà¹ØÎĵµ£º
MDSYS.CS_SRS ----- ¸Ã±í¶¨ÒåÁË×ø±êϵµÄÃû×Ö¼°ÆäÔÚOracle SpatialÖеÄIDÖµµÈ£¬ÕâЩ×ø±êϵ¶¼ÊÇÓÉOpen-GIS¹«²¼µÄ¡£Ä¿Ç°¶¨ÒåµÄ×ø±êϵÒѾ´ïµ½1018¸ö¡£
MDSYS.SDO_ANGLE_UNITS ----- ¸Ã±í¶¨ÒåÁ˽Ƕȵ¥Î»£¬·Ö±ðÊÇDegree,Gon,Grad,Minute,Radian,Second
MDSYS.SDO_DIST_UNITS ----- ¸Ã±í¶¨ÒåÁ˾àÀëµÄµ¥Î»¡£±ÈÈçkm,m£¬¹²ÓÐ27ÖÖ¾à ......
create or replace procedure aa1 is
v_aa varchar2(20);
v_bb varchar2(20);
va_aa varchar2(20);
va_bb varchar2(20);
va_number_aa number;
message varchar2(60);
CURSOR aas is
SELECT DISTINCT aa.aa, aa.bb from aa;
CURSOR aaas is
SELECT DISTINCT aaa.aa, aaa.bb from aaa where aaa.aa = v_aa ......
OracleÐÔÄÜÓÅ»¯¼¼ÇÉ
http://tech.it168.com/db/o/2006-06-15/200606151715426.shtml
1.Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ:
1.RULE(»ùÓÚ¹æÔò) 2.COST(»ùÓڳɱ¾) 3.CHOOSE(Ñ¡ÔñÐÔ)
ÉèÖÃȱʡµÄÓÅ»¯Æ÷,¿ÉÒÔͨ¹ý¶Ôinit.oraÎļþÖÐOPTIMIZER_MODE²ÎÊ ......
ÔÚϵͳǨÒÆ»òÉý¼¶µÄʱºò£¬¿ÉÄÜ»áÓÐ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 ......
ÔÚÊý¾Ý¿âÖУ¬ÓÐÁ½¸öÓû§usera£¬userb£¬Èç¹ûÔÚbÖÐÓиö´æ´¢¹ý³Ì£¬ÐèÒªÓÃaµÄÓû§È¥µ÷Ó㬣¨±ÈÈçbÊÇȨÏ޺ܸߵÄÓû§£¬¶øaÖ»ÊÇÆÕͨÓû§£¬ÎªÁËÆÁ±Î¸øa×îСµÄȨÏÞÖ»ÄÜÈç´Ë£©¡£ÓÚÊÇ£¬ÎÒ¾ÍÓÃgrant execute on ´æ´¢¹ý³ÌÃû to usera¡£ÕâÑù£¬ÔÚaµÄÓû§ÏÂÃæ¾ÍÄÜ¿´µ½´æ´¢¹ý³ÌÁË£¬µ«ÊÇÎÒÖ´ÐÐÒԺ󣬻¹ÊDZ¨ora-1031£¬ËµÊÇûÓÐȨÏÞ£¬¾¹ýÓ ......