ÓÃVCÔõô¿ª·¢OracleµÄÓ¦ÓóÌÐò£¿²»ÓÃODBC
VC¿ª·¢SQL SERVERµÄÓ¦ÓóÌÐòÎÒÓÃADO VC¿ª·¢MySQLµÄÓ¦ÓóÌÐòÎÒÓà MySQLµÄ¿ª·¢°ü£¬×°ÉÏÖ®ºó£¬ÔÚVCÀïÉèÖÃһϷ¾¶¾ÍÄÜ¿ª·¢ÁË ¾Í¸úVCÀïÉèÖÃSDK·¾¶Ò»Ñù µ«ÊÇÎÒÏÖÔÚÒªÓÃVC¿ª·¢OracleµÄÓ¦ÓóÌÐò£¬ÔÚÍøÉÏËÑÁËËÑ£¬´ó²¿·Ö¶¼ËµÊÇÓÃODBC£¬ ÎÒʵÔÚ²»ÏëÓÃODBC£¬Îҷdz£ÏëÓÃÏñMySQL ÄÇÑùµÄ¿ª·¢°ü¡£ ËùÒÔÎÒµÄÎÊÌâ¾ÍÊÇOracleÓÐûÓÐÕâÑùµÄ¿ª·¢°ü£¿ ¾ÍÊÇÌṩһ´ó¶ÑµÄ.hÎļþºÍ.libÎļþÓÃÓÚVCµÄ¿ª·¢£¿ ÌØ±ðÊÇOracle 10gµÄ£¬ÒÔΪÎÒµçÄÔÉÏ×°µÄ¾ÍÊÇOracle 10g
ÄãÊÇÒªÁ¬½ÓÊý¾Ý¿âÂð?? »¹ÊÇÒª¿ª·¢oracle Êý¾Ý¿â??? Èç¹ûÖ»ÊÇÏñodbcÕâÑùsdkÁ¬½øÈ¥£¬Äã¿ÉÒÔÈ¥ÏÂÔØÒ»¸ö½Ð×öÊÇ oracle client µÄ¶«Î÷£¬oracle ÍøÉÏÓ¦¸ÃÓС£ ÊÔÊÔoledbÊÔÊÔ°É ÓÐ oci Äã°Ù¶ÈһϾÍÖªµÀÁË Õâ¸öÊÇoracleÌṩµÄ½Ó¿Ú ²»¹ýÕâ¸ö½Ó¿Ú±È½Ï¸´ÔÓ ÍøÉÏÓкܶ࿪ԴÏîÄ¿ÌṩÁË·â×° ½¨ÒéÓ÷â×°ºóµÄ½Ó¿Ú£¬ÓÃÆðÀ´¼òµ¥ ÓÃOCI£¬»òOTL£¬Ç°ÌáÊǰ²×°ORACLE¿Í»§¶ËÒýÓà ÓÐ oci Äã°Ù¶ÈһϾÍÖªµÀÁË Õâ¸öÊÇoracleÌṩµÄ½Ó¿Ú ²»¹ýÕâ¸ö½Ó¿Ú±È½Ï¸´ÔÓ ÍøÉÏÓкܶ࿪ԴÏîÄ¿ÌṩÁË·â×° ½¨ÒéÓ÷â×°ºóµÄ½Ó¿Ú£¬ÓÃÆðÀ´¼òµ¥ ͬÒâ¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿ Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£ ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠ÒýÓà ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠²»ÄÜ ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷ µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿ È磺 ......