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

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();


Ïà¹ØÎÊ´ð£º

linux»·¾³ÏÂgethostbynameº¯ÊýÎÊÌâ - C/C++ / CÓïÑÔ

дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
   
  struct hostent *hp; 
char AlarmDevIP[20];  
  int x2;

hp = gethostbyname("www.google.com");
if (hp)
{ ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......

C/C++ÖÐÓÐûÓиñʽ»¯UÅ̵ĺ¯Êý - C/C++ / C++ ÓïÑÔ

´ó¼ÒºÃ£º
ÎÒÏëʵÏÖ¼ì²âµ½²åÈëSD¿¨ºó×Ô¶¯½«SD¿¨¸ñʽ»¯µÄ¹¦ÄÜ£¬²»ÖªC/C++ÖÐÓÐûÓиñʽ»¯UÅ̵ĺ¯Êý£¿
ÁíÍ⣬ÎÒ²»ÏëʹÓÃSHFormatDrive£¬ÒòΪÕâ¸öº¯Êý»áµ¯³öÊÇ·ñÒª¸ñʽ»¯µÄÌáʾ¿ò£¬ÎÒÐèÒªµÄÊÇϵͳ×Ô¶¯¸ñʽ»¯£¬¶ø²Ù×÷Õß² ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

c¾²Ì¬±àÒëÁíÒ»¸öÎļþ¼ÐµÄ¿âº¯Êý - C/C++ / CÓïÑÔ

ÔÚ¸ùĿ¼/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Öж¨ÒåµÄ·½·¨ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ