在线等, 使用OCCI接口调用函数用out参数获取数组的问题

fzy8888cn

ORACLE 函数代码, 用out参数返回一个数组

1. 
   
2. CREATE OR REPLACE TYPE OBJ AS OBJECT ( Id NUMBER(10), name VARCHAR2(32) );
   
3. CREATE OR REPLACE TYPE OBJ_ARRAY AS TABLE OF OBJ;
   
4. 
   
5. 
   
6. CREATE OR REPLACE FUNCTION GetCollection (objs OUT OBJ_ARRAY) RETURN BINARY_INTEGER AS
   
7.     vret BINARY_INTEGER;
   
8. BEGIN
   
9.     objs := OBJ_ARRAY();
   
10. 
    
11.     for i in 1..5
    
12.     loop
    
13.             objs.extend();
    
14.         objs(objs.Last) := OBJ(i, "test");
    
15.     end loop;
    
16. 
    
17.     vret := 0;
    
18.     RETURN vret;
    
19. END GetCollection;
    

复制代码

C++代码, 调用ORACLE函数, 并用getVector 取出数组,结果捕获到OCI-21500错误!

1. 
   
2. #include <stdlib.h>
   
3. #include <occi.h>
   
4. #include <iostream>
   
5. #include <string>
   
6. #include <stdexcept>
   
7. 
   
8. #include "ott/map.h"
   
9. 
   
10. using namespace oracle::occi;
    
11. using namespace std;
    
12. 
    
13. int main(int argc, char** argv)
    
14. {
    
15.     try
    
16.     {
    
17.         string user = "test";
    
18.         string passwd = "test";
    
19.         string db = "test";
    
20. 
    
21.         Environment* env = Environment::createEnvironment (Environment::OBJECT);
    
22.         map(env);
    
23. 
    
24.         Connection* conn = env->createConnection (user, passwd, db);
    
25.             Statement* stmt = conn->createStatement("BEGIN :1 := GetCollection(:2); END;") ;
    
26. 
    
27.         stmt->registerOutParam(1, OCCIINT);
    
28.         stmt->registerOutParam(2, OCCIVECTOR, 0, "OBJ_ARRAY");
    
29.         stmt->execute();
    
30. 
    
31.             int code = stmt->getInt(1);
    
32. 
    
33.             cout << "RetCode = " << code << endl; -- Prints "RetCode = 0"
    
34. 
    
35.         std::vector< RefAny > vObjs;
    
36.         getVector(stmt, 2, vObjs);    -- 执行到这行时, 捕获 OCI-21500: 而且还是内部错误.        
    
37. 
    
38.         conn->terminateStatement(stmt);
    
39.         env->terminateConnection(conn);
    
40.         Environment::terminateEnvironment(env);
    
41.     }
    
42.     catch(SQLException& ex)
    
43.     {
    
44.         cerr << "Program raised exception " << ex.getErrorCode()
    
45.                 << " with text:" << endl << ex.getMessage().c_str() << endl;
    
46.         return EXIT_FAILURE;
    
47.     }
    
48.     catch(std::exception& ex)
    
49.     {
    
50.          cerr << "Program raised std::exception: " << ex.what() << endl;
    
51.          return EXIT_FAILURE;
    
52.     }
    
53.     catch(...)
    
54.     {
    
55.          cerr << "Unhandled exception." << endl;
    
56.          return EXIT_FAILURE;
    
57.     }
    
58. 
    
59.     return EXIT_SUCCESS
    
60. }
    

复制代码

fzy8888cn

自己顶一下

fzy8888cn

再顶

fzy8888cn

已解决