Selecting a LOB Column into a LONG Buffer Using a Simple Fetch

Selecting a LOB Column into a LONG Buffer Using a Simple Fetch

The following example illustrates selecting a LOB column using a simple fetch:

void simple_fetch()
   
   

{
   
   

  word i, buf1 = 0;
   
   

  word retval;
   
   

  text buf[15000];
   
   

  text *selstmt = (text *) "SELECT AD_SOURCETEXT FROM PRINT_MEDIA WHERE PRODUCT_ID = 2004";
   
   

  OCIStmtPrepare(stmthp, errhp, selstmt, (ub4)strlen((char *)selstmt),
   
   

                 (ub4) OCI_NTV_SYNTAX, (ub4) OCI_DEFAULT);
   
   

  retval = OCIStmtExecute(svchp, stmthp, errhp, (ub4) 0, (ub4) 0,
   
   

                          (const OCISnapshot*) 0, (OCISnapshot*) 0,
   
   

                          (ub4) OCI_DEFAULT);
   
   

  while (retval == OCI_SUCCESS || retval == OCI_SUCCESS_WITH_INFO)
   
   

  {
   
   

    OCIDefineByPos(stmthp, &defhp[1], errhp, (ub4) 2, (dvoid *) buf,
   
   

                   (sb4) sizeof(buf1), (ub2) SQLT_CHR, (dvoid *) 0,
   
   

                   (ub2 *) 0, (ub2 *) 0, (ub4) OCI_DEFAULT);
   
   

    retval = OCIStmtFetch(stmthp, errhp, (ub4) 1,
   
   

                          (ub4) OCI_FETCH_NEXT, (ub4) OCI_DEFAULT);
   
   

    if (retval == OCI_SUCCESS || retval == OCI_SUCCESS_WITH_INFO)
   
   

      DISCARD printf("buf = %.*s/n", buf2);
   
   

  }
   
   

}