how to select multiple blob columns ?

From: Ofir <ofir_gilboa_at_hotmail.com>
Date: Tue, 26 Oct 1999 13:48:10 +0200
Message-ID: <381594FA.D5178E75@hotmail.com>

Hi

i'm using OCI functions and i'm trying to select multiple rows that contain blob's.
in the book "OCI programming Advanced Topics" on page 5-11 it say:

---

OCILobLocator * lob_array[10];
...

for (i=0; i<10, i++)

	lob_array[i] = OCIDescriptorAlloc(...OCI_DTYPE_LOB...);
                                     /* initialize array of locators */

...

OCIBindByName(...,(dvoid *) lob_array,...); OCIStmtExecute(...,10,...); /* 10 is the iters parameter */

---

but it refer to "INSERT" statement.
i try to use it the same way but with "SELECT" statement and it doesn't work.
it seems to thrown an exception when trying to perform the "OCIStmtExecute" statement.

does anyone know how to select multiple blob rows ? i will appreciate any help (even with DBMS_LOB functions) thank you

Ofir

ofir_gilboa_at_hotmail.com Received on Tue Oct 26 1999 - 06:48:10 CDT