ANSI Dynamic SQL and LOBs

From: Robert J. Rubin <>
Date: Thu, 12 Aug 1999 14:45:12 -0500
Message-ID: <VtFs3.315$>

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?


    -Robert Received on Thu Aug 12 1999 - 21:45:12 CEST

Original text of this message