ANSI Dynamic SQL and LOBs

From: Robert J. Rubin <rubin_at_no-spam-istation.com>
Date: Thu, 12 Aug 1999 14:45:12 -0500
Message-ID: <VtFs3.315$gZ2.6146_at_dfw-read.news.verio.net>

How do I write ANSI Dynamic SQL (method 4) and retreive LOBs?

I am writing some middleware using Pro*C where I am attempting to "select *" from a table and "do the right thing" as I discover the layout of the table dynamically.

An aside, I notice that when I DESCRIBE OUTPUT USING DESCRIPTOR, a date column is returned as type 9 (ANSI DATE) as I'd expect. However if on the same column I SET DESCRIPTOR TYPE= :type9, the ORACLE library throws during a fetch. Why?

Thanks,

    -Robert
    rubin_at_no-spam.istation.com Received on Thu Aug 12 1999 - 21:45:12 CEST