[Info-vax] Storing LOBV values via Java
CodeAmazon
shastaw at gmail.com
Sat Jan 3 18:29:31 EST 2009
I am trying to copy records from an Oracle9i database to an Oracle/RDB
database on an OpenVMS server. A Java program collects the data from
the former and inserts the records into the latter if they match
various criteria. For the most part, this goes well.
However, in the source there is a table of comments which are to be
entered as a concatenated String with some timestamp information in
the destination. The db admin set the target up as an LOBV:
CAD LIST OF BYTE VARYING
Segment Length: 80
I currently create a row with everything but the comments, then
concatenate per the requirements, and finally want to update the new
record with the prettified comment. I have utterly failed to insert
this value into the database as a LOBV (or by pretending it's a
BLOB.) Can someone tell me how to insert my data -- currently a large
String -- into the LOBV field (or point me to a tutorial?)
- Shasta
More information about the Info-vax
mailing list