!   -ÌŸ Ì;L[ht�Œ™¥²¾ÊÌ-b.|/—0¥1µ2Ü3ð4 5&6<7\8s9�:³;ËáµLªk­«·s¶}±Ò¿é¤JÀÉ¥H¨ÑŪ¨úµLªk¶}±Ò¥N½X²£¥Í¿é¥XÀÉ "%s"µLªk¶}±Ò¨Ö¤JÀÉC ¨ç¼Æªº«Å§iµL®Ä±N·sÂÂÃþ«¬ªº C ¨ç¼Æ«Å§i²V¦X¨Ï¥Î¤£¦X³W©wC ¨ç¼Æªº¦WºÙ¤£¦X³W©w¥u¦b³æ¤@°Ñ¼Æ®É¤~¥i¨Ï¥ÎµL®Ä¦b¦¹¨ç¼Æ«Å§i¤¤»Ý­n³]©wÃѧO¦r¥¿¦¡°Ñ¼Æªº«Å§i¤£¦X³W©wVARCHAR ªº¥¿¦¡°Ñ¼Æ¥²¶·«Å§i¬°«ü¼Ð¤£¯à¦³ VARCHAR ¦ì¤¸Äæ¦ìVARCHAR ªº°}¦C¼Æ¤£¥i¤j©ó 2 ºûVARCHAR ªº«Å§i®æ¦¡¿ù»~ - ¥¼³]©wªø«×µLªkµû¦ôªí¥Ü¦¡ªº±`¼Æ¤j¤pµLªk±Nªí¥Ü¦¡µû¦ô¬°±`¼Æ<n=Ž>¦?¶@ÊAêBCDAE_FoGƒH—I¥J·KËLÛò¦b±`¼Æªí¥Ü¦¡¤¤¦³¤£¦X³W©wªº¹Bºâ¤l«¬ºAÂà´«Ãþ«¬ªí¥Ü¦¡¤£¥¿½T¿òº|¤FÃþ«¬ªí¥Ü¦¡ªí¥Ü¦¡Ãþ«¬»P¥Îªk¤£²Åºâ³Nªí¥Ü¦¡¤¤¨S¦³¥¿½Tªº¹Bºâ¤¸Ãþ«¬¦b¨â­Ó«ü¼Ð¶¡¥u¥i¨Ï¥Î´îªkµo²{¥¼©w¸qªºÃѧO¦r¦bªí¥Ü¦¡¤¤¥Î¤FÃþ«¬©w¸q¦WºÙ (­ì¥»À³¨Ï¥Î¤@¼Æ­È)¨Ï¥Î¤FÅܼƦWºÙ§@¬°Ãþ«¬©w¸q¦WºÙ¶¡±µ¹Bºâ¤£¦X³W©wµ²ºc°Ñ¥Î¹Bºâ¤£¦X³W©w»Ý³]©wµ²ºc©Îµ²ºc«ü¼Ðµ²ºc¦¨­û¥¼©w¸q°Ñ·Ó¨ì¥¼«Å§iªº¨ç¼Æ»Ý­n¾ã¼ÆÃþ«¬ªºªí¥Ü¦¡SQL ÃѧO¦r¥¼©w¸q¹Á¸Õ­«·s©w¸q SQL ÃѧO¦rMbNzO�PªQÂRÚSöT U V4WjX‚Y§ZØ[ëþSQL ÃѧO¦r¥¼«Å§i¬°±Ô­z¥ySQL ÃѧO¦r¥¼«Å§i¬°´å¼Ð´å¼Ð¥DÅé¶·©R¦W±Ô­z¥yÃѧO¦r¥D¾÷Åܼƪí¥Ü¦¡ªºÃþ«¬µL®ÄµLªk¹ï¦¹Ãþ«¬«Å§i¦hºû°}¦Cµ²ºc¥]§t¤@­Ó±_ª¬ªºµ²ºc©ÎÁp¶°¥D¾÷ÅܼƤ£¥i¬°Áp¶°Ãþ«¬µ²ºc¥]§t¤@­Ó¦ì¤¸Äæ¦ì¥D¾÷ÅܼƪºÃþ«¬¤£¥¿½T¦b´å¼Ð¤W¨Ï¥Î WHERE CURRENT OF ªí¥Ü¤£¥Î FOR UPDATE ¤l¥y´å¼Ðªº¥DÅé¶·¬°¬d¸ßªí¥Ü¦¡¥D¾÷Åܼư}¦C¤j¤p¤£²Å. ¨Ï¥Î³Ì¤p­È: %ld¨Ï¥Î¤º§tªº PL/SQL °Ï¶ô®É¶·¨Ï¥Î SQLCHECK=SEMANTICSPL/SQL ¤¤¦³»y·N¿ù»~PL/SQL ¤¤¦³»yªk¿ù»~ \V]q^…_š`´aÊbócd8e_f}g£hÎøEXEC IAF ±Ô­z¥y¤£¤¹³\«ü¥Ü¾¹¦¹Ãþ«¬¥²¶·³]©wºë½T«×µLªk»P¦¹ SQL Ãþ«¬µ¥­È¸ê®ÆÃþ«¬ªºµ¥­È¹Bºâ¤£¦X³W©w¶W¥X PL/SQL ªº³sµ²¦ì¸m²Ä %d ¦æ, ª½Äæ %d, ÀÉ®× %s µo¥Í»y·N¿ù»~: ¥H #include ©Ò¨Ö¤JªºÀɮפ£¥i§t¦³ SQL ±Ô­z¥yµL®Ä©Î§@¼oªº¿ï¶µ, ¤£¤©³B²z²Ä %d ¦æ, ª½Äæ %d, ÀÉ®× %s ³Bµo¥Íĵ§i: ¨ç¼Æ©I¥s¤£¯à§@¬°¥D¾÷Åܼƪí¥Ü¦¡¦b ARRAYLEN ¤§«áªºÃѧO¦r¶·¬°¤@°}¦C¦WºÙ³]©w ARRAYLEN ªºÃѧO¦r¶·¬O 4 ­Ó¦ì¤¸²Õªº¾ã¼Æ¦¹°}¦CÃþ«¬»P ARRAYLEN ±Ô­z¥y¤@°_¨Ï¥Î®ÉµL®Ä iPj‚k¥l¿máno+pIqzr�sÆtÖùARRAYLEN »P SQL ³sµ²°}¦C¤@°_¨Ï¥Î®É·|³Q²¤¹L¤£¤©³B²z¦b SQL DECLARE °Ï¬q¤¤¥¼«Å§i¥D¾÷Åܼƫü¥ÜÅܼƶ·¥Hµ²ºcªº§Î¦¡³]©w¥D¾÷µ²ºc¤Î¨ä«ü¥Ü½X¶·¦³¬Û¦PªºÄæ¦ì¼Æ«ü¥Ü¾¹°}¦C¤j¤p¤£¯à¤p©ó¥D¾÷°}¦C¤j¤p©R¥O¦æ¤Þ¼Æ MODE=ANSI ¤£¯à»P DBMS=V6 ¦@¥Î«ü¥Ü¾¹Åܼƥ²»Ý«Å§i¬°µu¾ã¼ÆÃþ«¬EXEC TOOLS ¥D¾÷ÅܼƬÛÃö¸ê°TÀô¹Ò¦WºÙªºÃþ«¬¤£¬O¦r¤¸EXEC TOOLS ¥D¾÷«ü¼ÐÅܼƤ£¬O¤@­Ó«ü¼ÐEXEC TOOLS MESSAGE ¥D¾÷ÅܼƪºÃþ«¬¤£¬O¦r¤¸FOR ¦r¥y¤£¦X³W©w¦b SELECT ±Ô­z¥y¤¤¤£¥i¨Ï¥Î FOR ¤l¥y uPvtw�x®yÚzö{|*~Jv€™�­á¦b EXEC SQL DECLARE °Ï¬q¤¤ªº«Å§iµL®ÄSQLCHECK ªº­È¶W¹L©R¥O¦æªº­È¦b¨ç¼Æªº¥DÅé¥~µo²{¤F SQL ±Ô­z¥y¦b DEF_SQLCODE = TRUE ®É, ±z¤£¥i«Å§i SQLCODE¤£¥i¨Ï¥Î¤ºÁô¦¡ÅܼƦr¤¸ªº°}¦C¥»°ê»y¨¥¦r¤¸ÅܼƪºÃþ«¬µL®ÄµLªk»P¥»°ê»y¨¥¦r¤¸ÅܼƵ¥­È§ó§ï¨Ï¥ÎªÌ±K½X®ÉµLªk«ü©w³s½u¼Ò¦¡·í¨Ï¥Î NLS_LOCAL=YES ®É±z¥²»Ý«ü©w MODE=ANSI ¹w´ÁÃþ«¬ OCIExtProcContext ªºªí¥Ü¦¡¿òº|¤F°}¦Cªø«×³]©w­È·í¨Ï¥Î NLS_CHAR ©M NLS_LOCAL=TRUE ®É¤£¤¹³\ CHAR_MAP ‚Jƒh„Š…º†å‡ ˆ1‰UŠ‚‹œŒ¼Ü AT ¤l¥y¦b³o¸Ì¬O¤£³Q¤¹³\¨Ï¥Îªº»Ý­n¤@­ÓÃþ«¬¬° sql_cursor ªºªí¥Ü¦¡¦b SELECT ±Ô­z¥y¤¤ªº FROM/WHERE ¤l¥y¤£¤¹³\¦³°}¦CSELECT ²M³æ¤¤¤£¤¹³\¦³°}¦C³Q·í§@¿é¤J³sµ²ÅܼƨS¦³¹J¨ì EXEC SQL CONTEXT USE ±Ô­z¥yµ{¦¡¹ê»Ú°õ¦æ¬ÛÃö¸ê°TÀô¹ÒÅܼƪºÃþ«¬¤£¥¿½T¤w¸g¦b EXEC SQL DECLARE SECTION ¤§¤¤¦b EXEC SQL DECLARE SECTION ¤¤µo²{¦³ SQL ±Ô­z¿é¤JÀɦWºÙ»P¿é¥XÀɦWºÙ¬Û¦P·í¨Ï¥Îµ²ºcªº°}¦C®Éµ²ºc¥²»Ý¦³¦WºÙ¦bµ²ºcªº°}¦C¤º¨Ï¥Î°}¦C¬O¤£¦Xªkªº �VŽv�–�ɑ咓5”S•q–ƒ—«˜À™Ôé#includeÀɮפ¤¤£¥i¦³VARCHAR «Å§i¦b³o­Ó±Ô­z¤¤¤£³B²z¦¹Ãþ«¬ªº«ü¥Ü¾¹ DBMS=V6 ¦³¤£¦Xªkªº CHAR_MAP ¿ï¶µ­È. ¿ï¶µ¤£¤©³B²z.¦¹¥D¾÷Åܼƥ²¶·«Å§i¬°«ü¼ÐÃþ«¬¥Ø«e¤£¤ä´©¦¹Ãþ«¬ªº¥D¾÷Åܼư}¦C·í¨Ï¥Îª«¥ó§Ö¨ú°O¾ÐÅé®É»Ý¦³ Pro*C ¿ï¶µ OBJECTS=YES ¦¹¥D¾÷Åܼƪº«ü¥Ü¾¹ÅܼÆÃþ«¬µL®Ä³o­Ó«ü¥Ü¾¹Åܼƻݫŧi¬°«ü¼ÐÃþ«¬ÅܼƬ°¥¼©w¸qªºÃþ«¬®æ¦¡¥u¯à¬° 'RETURN[ING] REF INTO :'ª«¥ó»P REF Ãþ«¬¤£¬Û²Å¹w´Áª«¥óÃþ«¬ªºªí¥Ü¦¡¹w´Á REF Ãþ«¬ªºªí¥Ü¦¡ šP›hœŽ�¸žÖŸì ¡7¢W£¤§¥Åå¹w´Á¬Y¨Ç¶°¦XÃþ«¬ªºªí¥Ü¦¡INDICATOR ´y­z°Ï¶µ¥Ø¥D¾÷ÅܼƪºÃþ«¬µL®Ä¤£¤¹³\ FOR ¤l¥y©ó OBJECT GET ©Î SET ±Ô­z¥yÄݩʼƥػP¥D¾÷Åܼƪº¼Æ¥Ø¤£¬Û²ÅÄݩʤ£¦s¦b¯S©wªºª«¥ó¤¤µLªk¾Þ±±ª«¥óÄݩʦb OBJECT GET ©Î SETª«¥ó©ó OBJECT GET ©Î SET ¤¤¥²¶·¤£¬°°}¦CÄݩʻP¥D¾÷Åܼƶ¡ªºÃþ«¬Âà´«¤£¥¿½TObject »P REF ¥D¾÷Åܼƶ¡ªº°}¦C¤j¤p¤£¬Û²ÅOBJECT SET ©Î GET ¤¤¤£¤¹³\¦³¥D¾÷Åܼư}¦C¤£§¹¾ãªº (©Î¿òº|) Ãþ«¬³W®æ»¡©ú¦¹¥D¾÷Åܼƻݭn¨Ï¥Î¤@­Ó«ü¥Ü¾¹ÅÜ¼Æ ¦V§|¨¢©ÀªÖ«ä¬­!®>¯[°|±¨²¾â¹ï¤wª¾ªº¬ÛÃö¸ê°TÀô¹Ò¿ï¶µ³]©w¤FµL®Äªº­È¥D¾÷ÅܼƦ³¤@­Ó¹ï¦¹¿ï¶µ­È¦Ó¨¥µL®ÄªºÃþ«¬­Èªº¼Æ¥Ø»P¥D¾÷Åܼƪº¼Æ¥Ø¤£¬Û²Å¦¹Äݩʤ£»Ý­n«ü¥Ü¾¹ÅܼÆLOB Ãþ«¬¤£¬Û®eªí¥Ü¦¡ªºÃþ«¬¤£¬O¥¿½Tªº¦r¤¸¦r¦êÃþ«¬½w½Ä°ÏÃþ«¬»P LOB Ãþ«¬¤£¬Û®e¹w´Á¬Y¨Ç¤º³¡ LOB Ãþ«¬ªºªí¥Ü¦¡¹w´Á¬Y¨ÇÀH·N LOB Ãþ«¬ªºªí¥Ü¦¡¹w´ÁÃþ«¬¥~³¡ LOB (BFILE) ªºªí¥Ü¦¡µLªk¦b READ WRITE ¼Ò¦¡¤¤¶}±Ò¥~³¡ LOB (BFILE)¥D¾÷ÅܼƩMÄݩʰt¹ïµL®Ä¦b¥ô¦ó LOB ±Ô­z¥y¤¤§¡¤£®e³\ FOR ¤l¥y ³P´kµ�¶­·Á¸ä¹ÿº»J¼n½Œ¾³Ó¦¹Äݩʶȹ鷺³¡ LOB Ãþ«¬¦³®Ä¦¹Äݩʶȹï¥~³¡ LOB Ãþ«¬ (BFILE) ¦³®Ä¹w´Á¨ã¦³¤G¶i¦ì¾ã¼ÆÃþ«¬ªºªí¥Ü¦¡¤£®e³\¶°¦Xª«¥óªº°}¦C¦¹ COLLECTION ±Ô­z¥y¤£®e³\ FOR ¤l¥y¦¹Äݩʹ鷺³¡©Î¥~³¡ LOB ¦³®ÄÄݩʼƥػP¥D¾÷Åܼƪº¼Æ¥Ø¤£¬Û²Å¹w´Á¤@­Ó¦b 0 »P 65535 (³o¨âªÌ¤£¥]¬A¦b¤º) ªº­È·í³]©w¤F DYNAMIC=ANSI ®É¦¹¥Îªk¤~¦³®Ä´y­z°Ï»P«D´y­z°Ï¤l¥yªºµ²¦XµL®Ä¶È¦b PREPAREd °ÊºA±Ô­z¥y¤W USING ¤~¦³®ÄDEALLOCATE ±Ô­z¥y¤£®e³\ FOR ¤l¥y ¿PÀzÁŸµÃÍÄõÅÆMÇ|È©ÉÁÊÙóµLªk¦b LOB WRITE APPEND ¤¤³]©w¥Øªº¦a°¾²¾¶q¦b NLS_NCHAR ¿ï¶µ¤¤µLªk³]©w UCS2 ÅܼÆÃþ«¬¤£¯à¦P©ó UCS2 Ãþ«¬¥¼¦b¥i±²°Ê¼Ò¦¡¤¤«Å§i´å¼Ð°¾²¾¶q­È¦b ABSOLUTE ¤è¦V¼Ò¦¡¤¤¤£¯à¬°­t­È¡u¤@¯ë SQL «eºÝ¡vµo¥Í»y·N¿ù»~¨Ï¥Î OUTLINE ¿ï¶µ®É¥²¶·­n¨Ï¥Î SQLCHECK=SEMANTICS(FULL) ¿ï¶µ¨Ï¥Î OUTLINPREFIX ¿ï¶µ®É¥²¶·­n¨Ï¥Î OUTLINE ¿ï¶µ¨Ï¥Î RUNOUTLINE ¿ï¶µ®É¥²¶·­n¨Ï¥Î OUTLINE ¿ï¶µµLªk¶}±Ò¡u¤jºõ SQL¡vÀÉ®×µLªk¶}±Ò¡u¤jºõ¤é»x¡vÀɮפjºõ¦WºÙªø«×¶W¹L¤¹³\ªº­­¨îËÌ&2¤jºõ¼Æ¥Ø¤w¶W¹L­­¨îµLªk«Ø¥ß¤jºõÿÿÿÿ