BLOB writing/reading

From: Edward A. Walker <awalker_at_sombrero.cs.utexas.edu>
Date: 3 Sep 1998 22:05:08 GMT
Message-ID: <6sn3qk$h06$1@news.cs.utexas.edu>

Hello,

I am having problems using BLOB types. What I want to do is create an 180byte field used as a bitfield. Here's what I've done:

create table test (
bitfield blob,
id number);

insert into test values (empty_blob(), 1);

declare
 locator_var blob;

 amount_var integer;
 offset_var integer;
 buffer_var RAW;

begin
 amount_var :=12;
 offset_var:=1;
 buffervar := 1010;
 select bitfield into locator_var
  from test
  where id=1
   for update;
  DBMS_LOB.WRITE(locator_var, amount_var, offset_var, buffer_var); commit;
end;
/

The following errors occur:

 buffer_var RAW;

            *
ERROR at line 5:

ORA-06550: line 5, column 13:
PLS-00215: String length constraints must be in range (1 .. 32767)
ORA-06550: line 5, column 13:

PL/SQL: Item ignored

ORA-06550: line 9, column 2:
PLS-00201: identifier 'BUFFERVAR' must be declared
ORA-06550: line 9, column 2:

PL/SQL: Statement ignored
ORA-06550: line 14, column 55:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 14, column 3:
PL/SQL: Statement ignored

Thanks for any help

--
---
Allen Walker | University of Texas at Austin <awalker@cs.utexas.edu> | http://www.cs.utexas.edu/users/awalker Received on Thu Sep 03 1998 - 17:05:08 CDT