Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: OCI and ORDImage type extension
Will Kallander <wkallander_at_geocities.com> wrote in message
news:3771515a.0_at_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
There's some new OCI examples up on http://technet.oracle.com. I think they cover object types as well.
HTH. Finn Received on Wed Jun 23 1999 - 17:33:02 CDT