Can I read a LOB using Pro*C dynamic sql (sqlda)?

From: <todd_at_bi-tech.com>
Date: Wed, 29 Jul 1998 19:07:27 GMT
Message-ID: <6pnrtf$bef$1@nnrp1.dejanews.com>

I am trying to use dynamic sql within Pro*C, where a statement is generated dynamically and an sqlda structure is used to bind all columns to their corresponding data variables (I think this is referred to as dynamic method 4). This works fine for all of the "standard" data types, but I am unable to find any example of this using the LOB datatypes (CLOB, BLOB, etc.). I am unsure what C data type to use (BLOB perhaps?) and what type of structure to bind it to (OCIClobLocator perhaps?). I have called Oracle support but they have no examples either.

Has anyone been able to access a LOB using an sqlda structure? If so, can you post a code segment or example program?

Thanks for any help you can offer,
Todd Saylor
Bi-Tech Software

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 29 1998 - 14:07:27 CDT