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

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 Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

javaºÍoracle - °¤ÌßÖ°ÑÄ / ²ÅÈëÖ°³¡

±¾ÈËÏÖÔÚѧoracle ËãÊǸոÕÈëÒ»°ëÃÅ ÒÔºó»¹ÒªÑ§java ¸÷λ´óÏÀoracleºÃÈëÊÖ»¹ÊÇjavaºÃÈëÊÖ°¡ ÒÔºóÄǸö·½Ãæ·¢Õ¹»áºÃЩ
£¬ÎÒÔÝʱÓиöÏë·¨ÏëºÃºÃѧϰһÏÂÊý¾Ý¿âÒÔºóÍùÕâ·½±ã·¢Õ¹£¬±Ï¾¹Êý¾Ý¿â¸úл»´úûÓÐjavaÄÇô¿ì£¬²» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ