Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

³öÏÖ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µ¼³öexcelºÍexcelµ¼ÈëoracleµÄ¾­Ñé×ܽá

Ò»¡¢oracleµ¼³öexcel
·½·¨Ò»£º×î¼òµ¥µÄ·½·¨---Óù¤¾ßplsql dev
Ö´ÐÐFile =>new Report Window ¡£ÔÚsql±êÇ©ÖÐдÈëÐèÒªµÄsql£¬µã»÷Ö´Ðлò°´¿ì½Ý¼üF8£¬»áÏȳԳö²éѯ½á¹û¡£ÔÚÓҲ๤¾ßÀ¸£¬¿ÉÒÔÑ¡Ôñ°´Å¥Áí´æΪhtml¡¢copy as html¡¢export results£¬ÆäÖÐexport results°´Å¥ÖоͿÉÒÔµ¼³öexcelÎļþ¡¢csvÎļþ¡¢tsvÎļþ¡¢xmlÎļþ¡ ......

oracleѧϰ±Ê¼Ç£¨Ò»£©·ÖÏí

1¡¢»ù±¾Óï·¨
SELECT
from
WHERE
GROUP BY
HAVING
ORDER BY
SELECT:²éѯµÄ×Ö¶Î
1¡¢¿ÉÓÃ*±íʾËùÓÐ×ֶΡ£
2¡¢×Ö¶ÎÖ®¼äÓöººÅ·Ö¸î¡£
3¡¢¿ÉΪ×Ö¶ÎÆð±ðÃû Æä±ðÃû¿Éд³ÉSELECT AAAA¡£AA AS SS »ò AAAA¡£AA SS ¿ÉÊ¡ÂÔas
4¡¢¿ÉÖ±½Óд×Ö¶ÎÖµ£ºÈç SELECT AAAA¡£AA SS,'ÕÅÈý' NAME from ¡£¡£¡£
from:²éѯµÄ±íÃû
1¡¢±íà ......

Oracle Sequence Ïà¹Ø֪ʶ

Ò»£¬¼òµ¥½éÉÜ
    ÔÚoracleÖÐsequence¾ÍÊÇËùνµÄÐòÁкţ¬Ã¿´ÎÈ¡µÄʱºòËü»á×Ô¶¯Ôö¼Ó£¬Ò»°ãÓÃÔÚÐèÒª°´
ÐòÁкÅÅÅÐòµÄµØ·½¡£
1¡¢ create sequence
    ÄãÊ×ÏÈÒªÓÐcreate sequence»òÕßcreate any sequenceȨÏÞ£¬
    create sequence emp_sequence
   &n ......

Oracleº¯Êý

CLOB:ÓÃÀ´´æ´¢µ¥×Ö½ÚµÄ×Ö·ûÊý¾Ý
NCLOB:ÓÃÀ´´æ´¢¶à×Ö½ÚµÄ×Ö·ûÊý¾Ý
BLOB£ºÓÃÓÚ´æ´¢¶þ½øÖÆÊý¾Ý
BFILE:´æ´¢ÔÚÎļþÖеĶþ½øÖÆÊý¾Ý£¬Õâ¸öÎļþÖеÄÊý¾ÝÖ»Äܱ»Ö»¶Á·Ã¡£µ«¸ÃÎļþ²»°üº¬ÔÚÊý¾Ý¿âÄÚ¡£
CLOB£¬NCLOB£¬BLOB¶¼ÊÇÄÚ²¿µÄLOBÀàÐÍ£¬×4G£¬Ã»ÓÐLONGÖ»ÄÜÓÐÒ»ÁеÄÏÞÖÆ¡£
select lpad(to_number(nvl(max(classid),to_number( ......

OracleÕï¶Ï°¸Àý Spfile°¸ÀýÒ»Ôò

Çé¿ö˵Ã÷:
ϵͳ£ºSUN Solaris8
Êý¾Ý¿â°æ±¾:9203
ÎÊÌâÃèÊö£º¹¤³ÌÈËÔ±±¨¸æ£¬Êý¾Ý¿âÔÚÖØÐÂÆô¶¯Ê±ÎÞ·¨Õý³£Æô¶¯.¼ì²é·¢ÏÖUNDO±í¿Õ¼ä¶ªÊ§.
ÎÊÌâÕï¶Ï¼°½â¾ö¹ý³ÌÈçÏÂ:
 1. µÇ½ϵͳ¼ì²éalert.logÎļþ
¼ì²éalert.logÎļþÊÇͨ³£ÊÇÎÒÃÇÕï¶ÏÊý¾Ý¿âÎÊÌâµÄµÚÒ»²½
SunOS 5.8
login: root
Password:
Last login: Thu Apr 1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ