This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes    how to insert CLOB data type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "   how to insert CLOB data type" Watch "   how to insert CLOB data type" New topic
Author

how to insert CLOB data type

Makesh Sundaresan
Greenhorn

Joined: Nov 08, 2003
Posts: 4
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

Joined: Feb 18, 2003
Posts: 166
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.


Jeremy Wilson
 
 
subject: how to insert CLOB data type
 
Similar Threads
Clob Data Types
How to use oracle 9.2 driver for oracle817's CLOB?
Mapping String To CLOB datatype using WSAD 4.0
How to insert and retrieve the large objects (BLob,CLob,BFile) into oracle 8
Uploading xml to database