• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

how to insert CLOB data type

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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].
 
Ranch Hand
Posts: 166
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
reply
    Bookmark Topic Watch Topic
  • New Topic