CLOBs in Dynamic Sql

From: Tony Okrutny <tokrutny_at_tenebral.com>
Date: Fri, 16 Feb 2001 12:40:22 -0500
Message-ID: <t8qopvgorglf59@corp.supernews.com>

Has anyone been able to get CLOBs working (in select list) using Dynamic Sql method 4 in Pro*C? Either Oracle or Ansi dynamic sql will work.

I have had no luck. The Oracle documentation said to use ANSI dynamic sql instead of Oracle dynamic sql because it supported LOBs. However, all its examples convert everything to VARCHAR which results in an inconsitent datatype error when you try to select a CLOB.

Anyway, any help will be appreciated.
Tony Received on Fri Feb 16 2001 - 11:40:22 CST