CLOB Datatype and Visual Basic

[Jingpong]

I am not able to update or insert into an Oracle Table which has some field with a datatype CLOB. I am using VB.6, Oracle 8i and MDAC 2.5. Any idea?

Is there any special attension needed for thease data type. or Anyother specific ODBC Driver needed to do this.

Thanx in Advance.

Regards
Jing

 

[Jingpong]

No one is working with Oracle 8i and VB is it?

 

[Jingpong]

Any idea?

 

[Jingpong]

?

 

[ixian]

jingpong,

If you can get to a bookstore... or online bookstore and see if any one has
Wrox Press.....
Visual Basic Oracle Programmer's Reference

What does this book cover?


Oracle database structure
Oracle Objects for OLE(OO40)
ActiveX Data Objects (ADO)
SQL and PL/SQL
Transactions and triggers
Passing parameters to Stored Procedures
Returning resultsets from Stored Procedures
Building middle-tier COM objects for Oracle
Book overview

Oracle is the relational database of preference in the corporate world, and when combined with the rapid application capabilities of Visual Basic, provides a powerful base for developers. This provides a concise and yet comprehensive guide to accessing Oracle databases with Visual Basic. You'll also learn PL/SQL - the language of stored procedures and triggers. Throughout the book we combine theory and hands on practice. An example apllication shows how to guarantee data integrity both with oo40 and ADO.

Who is this book for?

This book assumes that the reader is familiar with Visual Basic and can develop simple applications. No prior knowledge of Oracle is required, although basic familiarity with any relational database is an advantage. This book is for those who wish to take Visual Basic past the beginning stage and into more complex database development with Oracle as the database server. While the focus will be on Oracle, many of the topics that are covered will be applicable to all database systems, especially server-based databases


Hope that helps a lil

Aaron
Fear is the mind killer!!!!!!