Example of using CLOB with embedded sql.

Folks,

  Where can I find a example source code in C and embedded SQL that uses   CLOB?   I have search google and c.d.o news group but I could not find it. Maybe I   am using wrong search pattern. I used INSERT CLOB EXAMPLE.

  I am new to Oracle and I am porting my DB2 code to Oracle. In DB2 I can   declare CLOB as

  struct {

           int ClobLen;
           char ClobStr[32000];
         } MyCLob;

   and use it as follows in EXEC SQL command:

   EXEC SQL INSERT INTO MYTABLE
      (MYINTCOL, MYCLOBCOL) VALUES (:MyInt, :MyClob);

   I do not have to use LOB Locators.

   How do I do it in Oracle?
   The examples I found are using OCI and Lob Locator.

   Thanks.

-- 
Hemant Shah                           /"\  ASCII ribbon campaign
E-mail: NoJunkMailshah_at_xnet.com       \ /  --------------------- 
                                       X     against HTML mail
TO REPLY, REMOVE NoJunkMail           / \      and postings      
FROM MY E-MAIL ADDRESS.           
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind,                Above opinions are mine only.
it's backed up on tape somewhere.      Others can have their own.