ÎÒÔÚÒ»¸ö´æ´¢¹ý³ÌÒªÔõô¼ÓËø£¬Ã¿´ÎÖ»ÄÜÓÉÒ»¸öÓû§ÆäËûÓû§Ö´ÐУ¬È»ºóÆäËûµÄÓû§ÒªµÈ´ý£¿¿ÉÒÔÕâÑù: ½¨Á¢¹ý³ÌA ×¼±¸µ÷Óùý³ÌB create procedure A is begin update table set column = ....; exex B; commit; end; / ÕâÑù¾Í¿ÉÒÔÁË
ÉÏÃæÐ´µÄÖ»ÊÇα´úÂë Ö´ÐÐupdateʱ»á¼ÓËø µ±ÄãÔÚÖ´ÐÐAʱ(AÖÐÖ´ÐÐB)±ðÈËÖ»Äܵȴý Ö±µ½Äãµ÷ÓÃB½áÊøºócommit SQL code: CREATE PROCEDURE proc_A IS BEGIN --ÊÖ¹¤¼ÓËø(Ö»ÓÐÒ»¸öÓû§Äܳɹ¦£¬ÆäËüÓû§±ØÐëµÈ´ý) SELECT * from temp FOR UPDATE; --temp±íÓÃÓÚ¼ÓËø --µ÷ÓÃproc_B proc_B; --×¢ÒâÒª´®ÐеĴ洢¹ý³ÌBÖв»ÄÜcommit,Èç¹û±ØÐëÌá½»¿ÉʹÓÃ×ÔÖÎÊÂÎñ --Ìá½»²¢ÊͷűíËø COMMIT; --ÆäËüÓû§¿ÉÒÔµ÷ÓÃproc_B END;
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......