·Ç³£¹îÒìµÄOCCIÎÊÌâ,linuxÏÂOK,AIXϸñƨ
ÎÒдÁËÒ»¸öOCCIµÄ³ÌÐò,¸Ã³ÌÐòÔÚlinuxÏÂÃæÔËÐÐÒ»ÇÐÕý³£,µ«ÊÇͬÑùµÄ´úÂëµ½AIXÏÂÔÙ±àÒëÔËÐоͳöÎÊÌâÁË.¶øÇÒÒ»´ÎÌá½»ÊýÁ¿µÄ²»Í¬,±¨µÄ´íÒ²²»Í¬.
C/C++ code:
#include <iostream>
#include <occi.h>
using namespace std;
using namespace oracle::occi;
#define ARRAY_SIZE 10
int main()
{
Environment *pEnv = NULL;
Connection *pCon = NULL;
Statement *pStmt = NULL;
try
{
pEnv = Environment::createEnvironment ((Environment::Mode)(Environment::OBJECT|Environment::THREADED_UNMUTEXED));
pCon = pEnv->createConnection("xxxx", "xxxxx", "xxxxxxxx");
pStmt = pCon->createStatement("insert into table(code) values (:1);");
}
catch(SQLException &ex)
{
cout<<"Error number: "<< ex.getErrorCode() << endl;
cout<<ex.getMessage() << endl;
return -1;
}
int pServID[ARRAY_SIZE];
ub2 pLen[ARRAY_SIZE];
for(int i = 0; i < ARRAY_SIZE; ++i)
{
pServID[i] =i*2;
pLen[i] = sizeof(pServID[i]);
}
try
{
pStmt->setDataBuffer(1,pServID, OCCIINT, sizeof(int), pLen,(sb2*)NULL,(ub2*)NULL);
//ORA-32109: invalid column or parameter position
pStmt->executeArrayUpdate(ARRAY_SIZE);
pCon->commit();
Ïà¹ØÎÊ´ð£º
дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
struct hostent *hp;
char AlarmDevIP[20];
int x2;
hp = gethostbyname("www.google.com");
if (hp)
{
......
×ÉѯQQ£º269562808
bzip2recover
¹¦ÄÜ˵Ã÷£ºÓÃÀ´ÐÞ¸´Ë𻵵Ä.bz2Îļþ¡£
Óï·¨£ºbzip2recover[.bz2ѹËõÎļþ]
²¹³ä˵Ã÷£ºbzip2ÊÇÒÔÇø¿éµÄ·½Ê½À´Ñ¹ËõÎļþ£¬Ã¿¸öÇø¿éÊÓΪ¶ÀÁ¢µÄµ¥Î»¡£Òò´Ë£¬µ±Ä³Ò»Çø
¿éËð»µÊ±£¬±ã¿ÉÀû ......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һÏ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......
ÎÒѧϰLinuxÓÐÒ»¶Îʱ¼äÁË£¬Ñ§Ï°¹ýshell½Å±¾±àд£¬¿´¹ý¡¶Unix¸ß¼¶»·¾³±à³Ì¡·£¬µ«ÊÇ×ܾõµÃ¿´µÄºÍдµÄ³ÌÐòºÜÉÙ£¬¾õµÃ¿´ÁËÖ®ºóûÓÐʲô×÷Óã¬Ö»ÊǼÇסÁËЩº¯Êý¶øÒÑ£¬Ã»ÓÐʵս¡£¶øÇҸоõÏÖÔÚѧϰLinuxºÜûÓз½Ïò£¬²»Ö ......
ÎÒÔÚLinuxÉÏ×°ÁËOracleÊý¾Ý¿â£¬ÆäÖÐÓÐÒ»¸ö±í£¬´óÔ¼ÓÐ90000ÌõÊý¾Ý£¬ÓÃOracle½øÐзÖÒ³²éѯµÄʱºò£¬·¢ÏÖºÜÂý
sqlÓï¾äÈçÏ£º
select *
from (select row_.*, rownum rownum_
from (select * ......