ͨ¹ý»º´æÊý¾Ý¿â½á¹ûÌá¸ßPHPÐÔÄÜ
PL/SQL ¿é£¬ËüΪ orders_nf_callback ֪ͨ´¦Àí³ÌÐò´´½¨²éѯע²á¡£
¡¡¡¡Çåµ¥ 3. Ϊ֪ͨ´¦Àí³ÌÐò´´½¨²éѯע²á DECLARE
Copyright ©1999-2011 ÏÃÃÅÁèÖڿƼ¼ÓÐÏÞ¹«Ë¾ ÏÃÃÅÓÅͨ»¥Áª¿Æ¼¼¿ª·¢ÓÐÏÞ¹«Ë¾ All rights reserved µØÖ·(ADD)£ºÏÃÃÅÈí¼þÔ°¶þÆÚÍûº£Â·63ºÅ701E£¨¶«ÄÏÈÚͨÅÔ£© Óʱà(ZIP)£º361008 µç»°£º0592-5908028 ´«Õ棺0592-5908039 ×ÉѯÐÅÏ䣺web@lingzhong.cn ×ÉѯOICQ£º173723134 ¡¶ÖлªÈËÃñ¹²ºÍ¹úÔöÖµµçÐÅÒµÎñ¾ÓªÐí¿ÉÖ¤¡·ÃöB2-20100024 ICP±¸°¸:ÃöICP±¸05037997ºÅ
regid NUMBER; ord_id NUMBER; qosflags NUMBER; BEGIN qosflags := DBMS_CHANGE_NOTIFICATION.QOS_RELIABLE + DBMS_CHANGE_NOTIFICATION.QOS_ROWIDS; REGDS := SYS.CHNF
Copyright ©1999-2011 ÏÃÃÅÁèÖڿƼ¼ÓÐÏÞ¹«Ë¾ ÏÃÃÅÓÅͨ»¥Áª¿Æ¼¼¿ª·¢ÓÐÏÞ¹«Ë¾ All rights reserved µØÖ·(ADD)£ºÏÃÃÅÈí¼þÔ°¶þÆÚÍûº£Â·63ºÅ701E£¨¶«ÄÏÈÚͨÅÔ£© Óʱà(ZIP)£º361008 µç»°£º0592-5908028 ´«Õ棺0592-5908039 ×ÉѯÐÅÏ䣺web@lingzhong.cn ×ÉѯOICQ£º173723134 ¡¶ÖлªÈËÃñ¹²ºÍ¹úÔöÖµµçÐÅÒµÎñ¾ÓªÐí¿ÉÖ¤¡·ÃöB2-20100024 ICP±¸°¸:ÃöICP±¸05037997ºÅ
regid := DBMS_CHANGE_NOTIFICATION.NEW_REG_START (REGDS); SELECT order_id INTO ord_id FROM orders WHERE ROWNUM£¼2; DBMS_CHANGE_NOTIFICATION.REG_END; END; / ¡¡¡¡±¾Ê¾ÀýÕë¶Ô ORDERS ±í´´½¨ÁËÒ»¸ö×¢²á£¬²¢½« orders_nf_callback ÓÃ×÷֪ͨ´¦Àí³ÌÐò¡£ÏÖÔÚ£¬Èç¹ûÄúʹÓà DML »ò DDL Óï¾äÐÞ¸Ä ORDERS ±í²¢Ìá½»ÊÂÎñ£¬Ôò½«×Ô¶¯µ÷Óà orders_nf_callback º¯Êý¡£ÀýÈ磬Äú¿ÉÄÜÕë¶Ô ORDERS ±íÖ´ÐÐÏÂÁÐ UPDATE Óï¾ä²¢Ìá½»¸ÃÊÂÎñ£º UPDATE ORDERS SET order_mode = ''direct'' WHERE order_id=2421; SELECT TO_CHAR(operdate, ''dd-mon-yy hh:mi:ss'') operdate, OPERDATE TBLNAME RSLT_MSG ½«±íÌí¼Óµ½ÏÖÓÐ×¢²á ¡¡¡¡Ç°Ò»²¿·Ö½éÉÜÁËÈçºÎʹÓøü¸Ä֪ͨ·þÎñʹÊý¾Ý¿âÔÚ×¢²á¶ÔÏó£¨ÔÚÒÔÉÏʾÀýÖÐΪ ORDERS ±í£©·¢Éú¸ü¸Äʱ·¢³ö֪ͨ¡£µ«´ÓÐÔÄܽǶȶøÑÔ£¬¿Í»§¶ËÓ¦ÓóÌÐò¿ÉÄܸüÏ£Íû»º´æ ORDER_ITEMS ±í¶ø·Ç ORDERS ±í±¾ÉíµÄ²éѯ½á¹û¼¯£¬ÕâÊÇÒòΪËüÔÚÿ´Î·ÃÎʶ©µ¥Ê±£¬²»µÃ²»´Ó ORDERS ±íÖÐÖ»¼ìË÷Ò»ÐУ¬µ«Í¬Ê±±ØÐë´Ó ORDER_ITEMS ±íÖмìË÷¶à¸öÐС£ÔÚʵ¼ÊÇé¿öÖУ¬¶©µ¥¿ÉÄÜ°üº¬ÊýÊ®¸öÉõÖÁÊý°Ù¸ö¶©µ¥Ïî¡£ ¡¡¡¡ÓÉÓÚÄúÒѾ¶Ô ORDERS ±í×¢²áÁ˲éѯ£¬Òò´Ë²»±ØÔÙ´´½¨Ò»¸ö×¢²áÀ´×¢²á¶Ô ORDER_ITEMS ±íµÄ²éѯÁË¡£Ïà·´£¬Äú¿ÉÒÔʹÓÃÏÖÓÐ×¢²á¡£Îª´Ë£¬ÄúÊ×ÏÈÐèÒª¼ìË÷ÏÖÓÐ×¢²áµÄ ID¡£¿ÉÒÔÖ´ÐÐÒÔϲéѯÀ´Íê³É´Ë¹¤×÷£º SELECT regid, table_name FROM user_change_notification_regs;¡¡¡¡½á¹û¿ÉÄÜÈçÏÂËùʾ£º REGID TABLE_NAME DECLARE CREATE TYPE rdesc_tab AS TABLE OF SYS.CHNF
Copyright ©1999-2011 ÏÃÃÅÁèÖڿƼ¼ÓÐÏÞ¹«Ë¾ ÏÃÃÅÓÅͨ»¥Áª¿Æ¼¼¿ª·¢ÓÐÏÞ¹«Ë¾ All rights reserved µØÖ·(ADD)£ºÏÃÃÅÈí¼þÔ°¶þÆÚÍûº£Â·63ºÅ701E£¨¶«ÄÏÈÚͨÅÔ£© Óʱà(ZIP)£º361008 µç»°£º0592-5908028 ´«Õ棺0592-5908039 ×ÉѯÐÅÏ䣺web@lingzhong.cn ×ÉѯOICQ£º173723134 ¡¶ÖлªÈËÃñ¹²ºÍ¹úÔöÖµµçÐÅÒµÎñ¾ÓªÐí¿ÉÖ¤¡·ÃöB2-20100024 ICP±¸°¸:ÃöICP±¸05037997ºÅ
|
|||||||||||||||
ÁèÖڿƼ¼×¨ÒµÌṩ·þÎñÆ÷×âÓᢷþÎñÆ÷Íйܡ¢ÆóÒµÓʾ֡¢ÐéÄâÖ÷»úµÈ·þÎñ£¬¹«Ë¾ÍøÕ¾£ºhttp://www.lingzhong.cn ΪÁ˸ø¹ã´ó¿Í»§Á˽â¸ü¶àµÄ¼¼ÊõÐÅÏ¢£¬±¾¼¼ÊõÎÄÕÂÊÕ¼¯À´Ô´ÓÚÍøÂç,ÁèÖڿƼ¼×ðÖØÎÄÕÂ×÷ÕߵİæȨ£¬Èç¹ûÓÐÉæ¼°ÄãµÄ°æȨÓбØҪɾ³ýÄãµÄÎÄÕ£¬ÇëºÍÎÒÃÇÁªÏµ¡£ÒÔÉÏÐÅÏ¢ÓëÎÄÕÂÕýÎÄÊDz»¿É·Ö¸îµÄÒ»²¿·Ö,Èç¹ûÄúҪתÔر¾ÎÄÕÂ,Çë±£ÁôÒÔÉÏÐÅÏ¢£¬Ð»Ð»! |