Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> OCI and ORDImage type extension

OCI and ORDImage type extension

From: Will Kallander <wkallander_at_geocities.com>
Date: Wed, 23 Jun 1999 14:29:06 -0700
Message-ID: <3771515a.0@news.cm2.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US