Oracle Report ´íÎó
ÎÒÔÚ×öÒ»¸öReprotʱ£¬ÔÚÆäÖÐдÁËÒ»¸ö¹«Ê½ÓÐselect into Óï¾ä¡£
µ±select Îó¾äÎÞ²éѯµ½¼Ç¼ʱ£¬¾Í³öÏÖ´íÎ󣬿ÉÒÔÓÃexceptionÈ¥´íÎó´¦Àí¡£
µ«ÏÖÔÚÎÒÏëÈñ¨±íÔÚ²éѯµ½Î޼Ǽʱ£¬¾Í²»ÔÙÖ´ÐнÓÏÂÀ´µÄ¶¯×÷£¬¸øÓû§Ìáʾ¡°Î޼Ǽ¡±£¬status²»ÊÇerror,ÊÇnormal
Ó¦ÈçºÎ×ö£¿
¿ÉÊÇÕâÑùµÄ»°£¬Ëü»¹»á¼ÌÐøÖ´ÐÐÏÂÈ¥¡£
±ÈÈç½ÓÏÂÀ´»¹ÈçÆäËüµÄ¹«Ê½µÈ£¬¼°±¨±íµÄÖ÷²éѯ¶¼»áÖ´×Å×ÅÖ´ÐУ¬Æäʵ¶¼ÊÇÎÞÒâÒåµÄ.
ÎÒÏë´Ëʱ¾ÍÖնϱ¨±íµÄÖ´ÐÐÁË¡£
ÄǾͶ¨ÒåÒ»¸öÓ¦ÓóÌÐòÒì³££¬ÔÚexceptionÀï²¶×½µ½no_data_found´íÎóºó£¬Å׳ö¸ÃÒì³£¡£
¾ÍÊDz»ÖªÔõô×öÂï
declare
e_nodata exception;
PRAMGA exception_init(e_nodata,-1403);
begin
...
select ... into ...;
...
exception
when e_nodata then
;--ÄãÏë¸ÉÂ𣬾ÍÔÚÕâ¸ÉÂð£¬Ö»ÒªºÏ·¨¡£
end;
suiziguo,ÎÒ²»ÊÇÒ»¸ö¹«Ê½»òÕß´æ´¢¹ý³Ì£¬ÊÇREPORT£¬Ëù¾ÙµÄÀýÊÇreportÖеÄÒ»¸ö¹«Ê½¡£
ÔÚ´ËʱÎÒÏëÒªÖÕÖ¹±¨±íµÄÖ´ÐУ¬ÇÒ°ÑÔÚ´Ë´¦²¶»ñµÄ´íÎóÐÅÏ¢·µ»Ø¸øÓû§¡£
²»Êǽö¶Ô´Ë¹«Ê½½øÐÐÒì³£´¦Àí¡£
ÓÐÇ¿ÖÆÖÕÖ¹±¨±íÖ´ÐеÄÓï¾äÂð£¿
srw.program_abortÇ¿ÖÆÖÕÖ¹±¨±íµÄÖ´ÐÐ
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......