images

[jamoji]

I am exporting some tables from SQLServer 7.0 to Oracle 8,and there are some image fields (stored as LONG RAW) when you import them into Oracle.But the problem is that only one LONG field is allowed per table.I converted them to CLOB,so I can have several images in one table,but when ASP people want to visualize them,they can't.I'm afraid it is something related to that CLOB field...What can i do to handle my images?
Thanks

[Shestakov]

If u can't change code of application, bat can change db model (AND TABLE WITH LOB IMAGE_FIELDS HAS PRIMARY KEY), than u can do following:
1) create number of tables with structure:
pk_field
long_raw_fileld
2) create view, that has structure as SQLServer table.
3) create instread triggers, that supply insert, update, delete commands on this view.

[Raminder]

Why CLOB? Images are not character objects and I think you need to use BLOB and then try.

[jamoji]

Thanks Raminder,I tried BLOb,but if I use BLOB fields,I can't work with that tables and make queries in SQL...I can handle the image but not the table...

[ales]

Please clarify.
What's the trouble with BLOB and SQL?
Why you can't work with that tables?

[jamoji]

I can't make selects from the table with BLOB field.I get :
SP2-0678: Column or attribute type can not be displayed by SQL*Plus

[ales]

May I ask how you expect SQL*Plus to show you an image?
I thing the response you got is clear enough: SQL*Plus cannot display an image.
If you stored an image in CLOB field you'd possibly destroy it because Oracle does converting on CLOB fields. Definitely, you can select that image from CLOB in SQL*Plus but I seriously doubt it would be useful.

If you need to extract an image to a file and see it you'll have to use some other tool than SQL*Plus (C, Java, VB).

You can also save it as an external LOB (=file) from within PL/SQL.

[Edited by ales on 03-26-2002 at 05:16 AM]

[jamoji]

Yes,I know I can't see an image with SQL*Plus...But maybe I could see the binary code.anyway it doesn't matter,the thing is I import the images in LONG RAW datatype as default from SQL Server,but I only can store one LONG RAW field per table,so the rest of the fields must be converted to BLOB or something.I just wanted to know if I'm doing that right.Another people later will have to see the images from Visual Basic,C or something else as you said...
Thanks

[ales]

IMHO you should convert all LONG RAWs to BLOBs.

See manual, there are many useful examples ...

http://otn.oracle.com/docs/products/...a76940/toc.htm

And yes, you do that right :-)).

A.

[jamoji]

Thanks Ales...I'll have a look to the manual and will try to import all that images at last.
Regards