Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to insert CLOB data type

 
Makesh Sundaresan
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
how to insert to CLOB data type & BLOB data type in oracle database.
how to retrive CLOB data type & BLOB data type from oracle
using ASP [vbscript].
 
Jeremy Wilson
Ranch Hand
Posts: 166
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have never done it with ASP but have with JDBC. If possible use the Oracle ADO .NET drivers from oracle. These driver make it much easier to do this.

Normally to insert you need to insert all data but the clob and get the primary key info back. After that update the blob in the record using a byte array.

When doing a query you get a type back that is a pointer to the database. At that point you read the bytes through an input stream.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic