A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Arduino in Action
this week in the
A special promo:
Enter your blog post or vote on a blogger to be featured in an upcoming Journal
how to insert CLOB data type
Joined: Nov 08, 2003
Oct 02, 2004 12:33:00
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].
Joined: Feb 18, 2003
Oct 06, 2004 12:38:00
I have never done it with ASP but have with
. 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.
I agree. Here's the link:
- if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
subject: how to insert CLOB data type
How to insert and retrieve the large objects (BLob,CLob,BFile) into oracle 8
Clob Data Types
Uploading xml to database
How to use oracle 9.2 driver for oracle817's CLOB?
Mapping String To CLOB datatype using WSAD 4.0
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013