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

pb9連½Óoracle數據庫

ÎÒµÄpb9連設ÖÃÍê連½Ó參數£¬connect using sqlca£»
²é¿´sqlca.sqlcode發現時為0µÄ£¬µ«ÊÇǶÈëʽµÄsql¾ÍÊÇ執Ðв»ÁË£¬
string ls
select material_id into :ls from  material_info where rownum =1 ;
²é¿´ls¾¹È»為¿Õ£¬sqlca.sqlcode 還ÊÇ為0µÄ£¬說Ã÷執ÐÐ沒ÓÐ發Éú錯誤¡£試Á˺Ã幾個£¬¶¼ÊÇ這樣µÄ£¬ÔÚpl/sqlÖÐ執ÐеͼÊÇÓÐÖµ£¬鬱悶ÖУ¬
µÚ¶þ個問題¾ÍÊÇÔÚ開發環¾³´ò開µÄ時ºò£¨沒ÓÐ運ÐУ©£¬單擊datawindowµÄcolumn£¬會彈³öÒ»個Ìáʾ¿ò£¬說ijij內´æµØÖ·²»ÄÜ為read ,確¶¨»òÈ¡Ïûºópb¾Í×Ô動Í˳ö¡£

請´ó¼ÒÖ¸½Ì¡£
1.connect using sqlcaºó»¹ÒªÅжÏÏ£¡
ÔÚÊý¾Ý¿â»­°åÖÐÖ´ÐÐÄØ£¬Óнá¹ûÂð£¡
2¡£PBÀÏ벡£¡×ÜÊdzöÏÖ¾Í֨װϰɣ¡£¡

ÕæÊÇ鬱悶°¡£¬ÕýÔÚÖØ裝£¬¿¨ÔÚÄÇ裡°ëÌì²»動°¡¡£

ÖØ裝Ö®áá還ÊÇ沒ÓÐÓ𡣬ÎÒÔÙ開發環¾³Ï£¬單擊databaseÄÇ個圖標£¬È»ááÔÚO90 Oracle 9.0.1ÏÂÅäÖúÃÒ»個數據庫£¬連½Ó¿ÉÒԳɹ¦£¬µ«ÊÇ雙擊tableÄÇ個節點£¬¾¹È»Ê²÷áÖµ¶¼沒ÓУ¬áá來ÎÒÓÐн¨Ò»個datawindowÒ²ÊÇÒ»個table¶¼沒ÓС£這ÊÇÎÒ們µÄ測試庫Õýʽ庫Ò²ÊÇ這樣£¬ÎÒÔÚpl/sqlÖÐÒ²ÊÇÓÐ數據µÄ£¬


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

pl/sql - Oracle / ¿ª·¢

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

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

eclipseÖÐÁ¬½ÓoracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨
ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off cli ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ