Postgres Pro
Downloads
Home   >   mailing lists

SQLCloseCursor() or SQLFreeStmt does not free memory allcated to read CLOB field in Oracle. - Mailing list pgsql-sql

From Vadivel Subramaniam
Subject SQLCloseCursor() or SQLFreeStmt does not free memory allcated to read CLOB field in Oracle.
Date
Msg-id OF658CBCAC.5846AEF9-ON65257031.003139F6-65257031.0031DAE1@flextronicssoftware.com
Whole thread Raw
List pgsql-sql
Tree view 
Hi,
                                                                                          This is query realated to
ODBCand CLOB field in Oracle. I feel some ofyou might have faced similar issue.  Any hint would help me.

            I am using a C++ application that connects to Oracle Database using   EasySoft ODBC driver. I face a
strangeproblem when freeing the memoryafter i fetch the CLOB data from the Oracle table.

      The piece of Code is below,
                                                                                                  char *pClobBuffer =
newchar[10485670];  // 10 MB
                                                           // Prepare the SQL statement

pgsql-sql by date:

Previous
From: KÖPFERL Robert
Date:
Subject: UNIT-tests and SQL
Next
From: Erik Wasser
Date:
Subject: 'show full processlist' in postgres?