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.
