Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> OCI and ORDImage type extension
I'm trying to manipulate an object that is an extension of the ORDImage-type
in an OCI app. Does anyone have any sample code that shows how to do
something analogous to this PL/SQL block?
declare
my_image mine.my_TY;
ctx RAW(4000);
begin
select mi.image into my_image
from my_tab mi
where mi.id=1
for update;
my_image.image.import(ctx);
update my_tab mi
set mi.image=my_image
where mi.id=1;
end;
the type is defined as:
create or replace type my_TY authid current_user as object(
image ORDSYS.ORDImage,
attrib number,
internal INTERNAL_TY,
locks LOCK_TY,
metadata BLOB,
ref REF_TY,
member procedure ...
);
Thanks for any assistance...
--Will
Received on Wed Jun 23 1999 - 16:29:06 CDT
![]() |
![]() |