RDBPROD: Is it possible to UPDATE individual segments in a BLOB (segmented string/list of byte varying)? (Doc ID 1371476.1)

Last updated on AUGUST 09, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.1.4.5 and later
HP OpenVMS Itanium
HP OpenVMS Alpha

Goal

Is it possible to use the SQL UPDATE command to alter individual segments of a BLOB?

For example:

SQL> declare x1 read only table cursor for select resume from resumes
cont> where employee_id = '00164';
SQL> declare x2 read only list cursor for select resume where current of x1;
SQL> open cursor x1;
%SQL-I-DEPR_FEATURE, Deprecated Feature: Keyword CURSOR used as an identifier
o
SQL> open x1;
SQL> fetch x1;
RESUME
97:2:4
SQL> open x2;
SQL> fetch x2;
%
RESUME
This is the resume for Alvin Toliver
SQL> fetch x2;
RESUME
Boston, MA
SQL> fetch x2;
RESUME
Oracle Corporation
SQL> fetch x2;
RESUME
%RDB-E-SEGSTR_EOF, attempt to fetch past the end of a segmented string


Can I change just one of the values in RESUME, for example from
"Oracle Corporation"
to
"ORACLE CORPORATION" ?

In Rdb, a BLOB is the same as a SEGMENTED STRING or  LIST OF BYTE VARYING.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms