Women in Technology

Hear us Roar



Article:
  SQL Data Types
Subject:   ANSI DataTypes for LOBs and Dynamic SQL
Date:   2009-04-02 12:40:48
From:   DeniseF
I am in the processing of implementing LOB support for an existing application using Pro*C Embedded SQL for ORACLE database. The application is utilizing ORACLE SQL Dynamic Method 4 and, since this method does not support LOBs and ORACLES recommendation is to use ANSI Dynamic SQL, I am converting it to ANSI Dynamic SQL method 4.


However, I am a wee bit confused at this point on data types when trying to create the dynamic SQL in ANSI. The documentation says you have to set the TYPE when you are setting the descriptor information. I don't see a data type specified for LOBs (BLOB or CLOB).


What is it?


Thanks in advance for your help!
Denise