[Info-vax] Storing LOBV values via Java

[Jan-Erik Söderholm]

CodeAmazon wrote:
> 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

List of byte varying can not be insterted just as any
"normal" field. Normaly one first insterts the rest of the
fields and the nopen a "BLOB cursor" and insters the BLOB...