c++ÔÚlinuxÏÂÔõôÑùÁ¬½ÓoracleÊý¾Ý¿â£¿
1¡¢Á¬½ÓÊý¾Ý¿âµÄÅäÖÃÎļþ¶¼ÐèÒªÄÄЩÄÚÈÝ£¿ ÎÒÖªµÀµÄÓÐÍøÂç·þÎñÃû¡¢Óû§ÃûºÍÃÜÂë¡£»¹ÐèÒªÆäËûµÄÂð£¿×îºÃ¸ø³öÀý×Ó£¡ 2¡¢ËÄܸø³öÒ»·Ýc++ÔÚlinuxÏÂÁ¬½ÓoracleµÄ´úÂëʵÀý£¬Ð»Ð»£¡
ÎÒÖ»ÖªµÀoracleÅäÖõ½ODBC. È»ºóOTL·ÃÎÊODBC¡£ oracle ÓÐAPIº¯Êý¿ÉÒÔÖ±½ÓÓᣠ¥Ö÷¿´¿´°É¡£ PROCÒýÓà PROC ÄÜ·ñ¸ø¸ö¾ßÌåÀý×Ó°¡£¿ proc»òÓÃoci¿â¶¼¿ÉÒÔ£¬oracle for linuxÏÂÁ½¸öµÄÀý×Ó¶¼ÓÐ ÅäÖÆÓëwindowsÒ»Ñù£¬ÔÚoracle_homeÏÂÓÐnetwork/admin/tnsnames.oraÎļþ£¬°ÑwindowsµÄÕâ¸öÅäÖÆÎļþCOPY¹ýÈ¥Ò²¿ÉÓá£ÒýÓà ÎÒÓÐÒ»·Ý¿ªÔ´µÄC++·â×°µÄOCI½Ó¿Ú£¬Ê¹Ó÷½Ê½ºÜ¼òµ¥£¬ÓëjavaµÄjava.sql.*ʹÓ÷½Ê½ºÜÀàËÆ¡£ÐèÒªµÄ»°Áô¸öÓÊÏä¡£ ÒÔÏÂÊDz¿·ÖÍ·Îļþ£¬¹©Ô¤ÀÀ¡£ C/C++ code/* #ifdef ORACALL32_EXPORTS #define __declspec(dllexport) #else #define __declspec(dllimport) #endif*/ #include<time.h>struct OCIEnv;struct OCIError;struct OCISvcCtx;struct OCIStmt;struct OCIDescribe;struct OCILobLocator;class CStatement;class CResultSet;/* * This class represents a connection to ORACLE database.*/class CConnection { friendclass CStatement; friendclass CResultSet;public: CConnection();virtual~CConnection();int connect(constchar*username,constchar*password,constchar*dblink);int disconnect();int commit();int rollback(); CStatement* createStatement(); CResultSet* getTableComments();
Ïà¹ØÎÊ´ð£º
дÁ˸ö²âÊÔ³ÌÐòÈçÏ struct hostent *hp; char AlarmDevIP[20]; int x2; hp = gethostbyname("www.google.com"); if (hp) {
......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
´ó¼ÒºÃ£º ÎÒÏëʵÏÖ¼ì²âµ½²åÈëSD¿¨ºó×Ô¶¯½«SD¿¨¸ñʽ»¯µÄ¹¦ÄÜ£¬²»ÖªC/C++ÖÐÓÐûÓиñʽ»¯UÅ̵ĺ¯Êý£¿ ÁíÍ⣬ÎÒ²»ÏëʹÓÃSHFormatDrive£¬ÒòΪÕâ¸öº¯Êý»áµ¯³öÊÇ·ñÒª¸ñʽ»¯µÄÌáʾ¿ò£¬ÎÒÐèÒªµÄÊÇϵͳ×Ô¶¯¸ñʽ»¯£¬¶ø²Ù×÷Õß² ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
ÔÚ¸ùĿ¼/libÖдæ·ÅÒ»¸ölog.c£¬log.h£¬²¢ÓÃÏÂÃæµÄÓï¾ä£º gcc -c log.c ar crv liblog.a log.o ±àÒë³öÒ»¸öliblog.a¾²Ì¬¿â£¬È»ºóÔÚÎļþ¼Ð£º/testfileÖд´½¨Ò»¸ötest.cºÍtestc.c£¬test.cÖÐÒýÓÃÁËtestc.cÖж¨ÒåµÄ·½·¨ ......