Length of a long raw field stored in the database > 32K in PL/SQL

In PL/SQL i want to retrieve the length of a long raw field stored in the database where the size is > 32K. Because a long raw variable in PL/SQL can have the max size of 32K the following works fine if the size stored in the database is <= 32K:

my_var LONG RAW;
my_length INTEGER;

BEGIN
  SELECT image
  INTO my_var
  FROM image
  WHERE name = 'name';
  my_length := length(my_var);
END; Is it possible to detemine the length (in PL/SQL) if the size is > 32K ?

Thanks in advance,

Regards, Kees Hakvoort.

c.m.j.hakvoort_at_fd.agro.nl Received on Mon Jul 13 1998 - 08:59:45 CEST